home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1998-05-26 | 36.0 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 8f e0 00 00 00 01 | 00 00 00 00 00 00 00 00 |........|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 01 00 00 00 10 | 56 45 52 53 49 4f 4e 20 |........|VERSION |
|00000210| 3d 20 20 20 33 2e 30 30 | 00 00 00 01 00 00 00 29 |= 3.00|.......)|
|00000220| 4d 53 20 53 61 6e 73 20 | 53 65 72 69 66 2c 20 30 |MS Sans |Serif, 0|
|00000230| 2c 20 38 2c 20 35 2c 20 | 31 33 2c 20 31 31 2c 20 |, 8, 5, |13, 11, |
|00000240| 31 31 2c 20 32 2c 20 30 | 0a 00 00 00 01 00 00 00 |11, 2, 0|........|
|00000250| 04 5f 71 62 66 00 00 00 | 01 00 00 00 06 50 69 78 |._qbf...|.....Pix|
|00000260| 65 6c 73 00 00 00 01 00 | 00 00 05 43 6c 61 73 73 |els.....|...Class|
|00000270| 00 00 00 01 00 00 00 01 | 34 00 00 00 01 00 00 00 |........|4.......|
|00000280| 06 50 69 78 65 6c 73 00 | 00 00 01 00 00 00 0a 5f |.Pixels.|......._|
|00000290| 63 6f 6e 74 61 69 6e 65 | 72 00 00 00 01 00 00 00 |containe|r.......|
|000002a0| 04 5f 71 62 66 00 00 00 | 01 00 00 00 11 01 00 07 |._qbf...|........|
|000002b0| 00 5f 64 61 74 61 2e 68 | ce 9f 00 00 82 24 00 00 |._data.h|.....$..|
|000002c0| 00 01 00 00 00 21 41 72 | 69 61 6c 2c 20 30 2c 20 |.....!Ar|ial, 0, |
|000002d0| 39 2c 20 35 2c 20 31 35 | 2c 20 31 32 2c 20 32 31 |9, 5, 15|, 12, 21|
|000002e0| 2c 20 33 2c 20 30 0a 00 | 00 00 01 00 00 00 0a 5f |, 3, 0..|......._|
|000002f0| 63 6f 6e 66 6c 69 63 74 | 73 00 00 00 01 00 00 00 |conflict|s.......|
|00000300| 07 5f 64 61 74 61 2e 68 | 00 00 00 01 00 00 00 06 |._data.h|........|
|00000310| 50 69 78 65 6c 73 00 00 | 00 01 00 00 00 05 43 6c |Pixels..|......Cl|
|00000320| 61 73 73 00 00 00 01 00 | 00 00 02 31 30 00 00 00 |ass.....|...10...|
|00000330| 01 00 00 00 05 5f 66 6f | 72 6d 00 00 00 01 00 00 |....._fo|rm......|
|00000340| 00 0a 5f 63 6f 6e 66 6c | 69 63 74 73 00 00 00 01 |.._confl|icts....|
|00000350| 00 00 00 0a 5f 63 6f 6e | 66 6c 69 63 74 73 00 00 |...._con|flicts..|
|00000360| 00 01 00 00 00 0c 6c 62 | 6c 43 6f 6e 66 6c 69 63 |......lb|lConflic|
|00000370| 74 73 00 00 00 01 00 00 | 00 11 01 00 07 00 5f 64 |ts......|......_d|
|00000380| 61 74 61 2e 68 4a 14 00 | 00 5f 23 00 00 00 01 00 |ata.hJ..|._#.....|
|00000390| 00 00 f5 fe f2 ff 20 02 | 01 00 00 00 dc 00 00 00 |...... .|........|
|000003a0| dc 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 46 3a 01 00 00 00 |........|..F:....|
|000003c0| 25 00 00 00 78 00 00 00 | 00 00 00 00 93 00 00 00 |%...x...|........|
|000003d0| 06 00 00 00 87 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| fc 03 00 03 00 55 00 00 | 26 00 06 00 47 1a 28 fe |.....U..|&...G.(.|
|000003f0| 05 00 23 29 fe 0e 00 54 | f4 00 00 f7 01 00 10 fc |..#)...T|........|
|00000400| 2d fd fe 0a 00 99 f4 02 | 00 f7 03 00 fe 03 00 55 |-.......|.......U|
|00000410| 04 00 04 00 54 48 49 53 | 07 00 45 4e 41 42 4c 45 |....THIS|..ENABLE|
|00000420| 44 08 00 54 48 49 53 46 | 4f 52 4d 07 00 52 45 46 |D..THISF|ORM..REF|
|00000430| 52 45 53 48 05 00 43 6c | 69 63 6b 2c 00 00 00 00 |RESH..Cl|ick,....|
|00000440| 00 ff ff 31 00 63 00 51 | 00 e1 00 a2 00 31 00 00 |...1.c.Q|.....1..|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000460| 00 00 00 11 00 00 00 73 | 00 00 00 01 00 00 00 00 |.......s|........|
|00000470| 29 00 00 00 dc 00 00 00 | 00 00 00 00 00 00 00 00 |).......|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 04 |........|........|
|00000490| 5f 71 62 66 00 00 00 01 | 00 00 00 0e 63 6d 64 43 |_qbf....|....cmdC|
|000004a0| 6c 65 61 72 46 69 6c 74 | 65 72 00 00 00 01 00 00 |learFilt|er......|
|000004b0| 00 0d 63 6f 6d 6d 61 6e | 64 62 75 74 74 6f 6e 00 |..comman|dbutton.|
|000004c0| 00 00 01 00 00 00 09 5f | 62 61 73 65 2e 76 63 78 |......._|base.vcx|
|000004d0| 00 00 00 01 00 00 00 0e | 5f 63 6f 6d 6d 61 6e 64 |........|_command|
|000004e0| 62 75 74 74 6f 6e 00 00 | 00 01 00 00 00 04 5f 71 |button..|......_q|
|000004f0| 62 66 00 00 00 01 00 00 | 00 09 5f 62 61 73 65 2e |bf......|.._base.|
|00000500| 76 63 78 00 00 00 01 00 | 00 00 08 5f 6f 66 66 6c |vcx.....|..._offl|
|00000510| 69 6e 65 00 00 00 01 00 | 00 00 0d 63 6d 64 45 78 |ine.....|...cmdEx|
|00000520| 65 63 75 74 65 51 42 46 | 00 00 00 01 00 00 00 0d |ecuteQBF|........|
|00000530| 63 6f 6d 6d 61 6e 64 62 | 75 74 74 6f 6e 00 00 00 |commandb|utton...|
|00000540| 01 00 00 00 04 5f 71 62 | 66 00 00 00 01 00 00 01 |....._qb|f.......|
|00000550| 3b fe f2 ff 20 02 01 00 | 00 00 22 01 00 00 22 01 |;... ...|.."...".|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | ff 3b 02 00 00 00 25 00 |........|.;....%.|
|00000580| 00 00 91 00 00 00 00 00 | 00 00 c9 00 00 00 05 00 |........|........|
|00000590| 00 00 bf 00 00 00 00 00 | 00 00 00 00 00 00 fc 03 |........|........|
|000005a0| 00 03 00 55 00 00 16 00 | 13 00 99 fc 43 f4 00 00 |...U....|....C...|
|000005b0| f4 01 00 f4 01 00 f6 02 | 00 fd fe 03 00 55 03 00 |........|.....U..|
|000005c0| 04 00 54 48 49 53 06 00 | 50 41 52 45 4e 54 08 00 |..THIS..|PARENT..|
|000005d0| 47 4f 4f 4e 4c 49 4e 45 | 16 00 13 00 99 fc 43 f4 |GOONLINE|......C.|
|000005e0| 00 00 f4 01 00 f4 01 00 | f6 02 00 fd fe 03 00 55 |........|.......U|
|000005f0| 03 00 04 00 54 48 49 53 | 06 00 50 41 52 45 4e 54 |....THIS|..PARENT|
|00000600| 09 00 47 4f 4f 46 46 4c | 49 4e 45 0d 00 4f 70 74 |..GOOFFL|INE..Opt|
|00000610| 69 6f 6e 31 2e 43 6c 69 | 63 6b 2c 00 00 00 00 00 |ion1.Cli|ck,.....|
|00000620| ff ff 0d 00 4f 70 74 69 | 6f 6e 32 2e 43 6c 69 63 |....Opti|on2.Clic|
|00000630| 6b 5e 00 00 00 00 00 ff | ff 31 00 31 01 32 00 31 |k^......|.1.1.2.1|
|00000640| 01 31 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.1......|........|
|00000650| 00 00 00 01 00 00 00 19 | 00 00 00 36 00 00 00 01 |........|...6....|
|00000660| 00 00 00 03 00 00 00 5a | 00 00 00 78 00 00 00 04 |.......Z|...x....|
|00000670| 00 00 00 00 29 00 00 00 | 22 01 00 00 00 00 00 00 |....)...|".......|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000690| 00 00 00 64 43 61 70 74 | 69 6f 6e 20 3d 20 22 43 |...dCapt|ion = "C|
|000006a0| 6f 6e 66 6c 69 63 74 73 | 20 6f 6e 20 72 6f 77 3a |onflicts| on row:|
|000006b0| 22 0d 0a 48 65 69 67 68 | 74 20 3d 20 31 37 0d 0a |"..Heigh|t = 17..|
|000006c0| 4c 65 66 74 20 3d 20 38 | 0d 0a 54 6f 70 20 3d 20 |Left = 8|..Top = |
|000006d0| 31 37 0d 0a 57 69 64 74 | 68 20 3d 20 31 35 38 0d |17..Widt|h = 158.|
|000006e0| 0a 4e 61 6d 65 20 3d 20 | 22 6c 62 6c 43 6f 6e 66 |.Name = |"lblConf|
|000006f0| 6c 69 63 74 73 22 0d 0a | 00 00 00 01 00 00 00 05 |licts"..|........|
|00000700| 6c 61 62 65 6c 00 00 00 | 01 00 00 00 05 6c 61 62 |label...|.....lab|
|00000710| 65 6c 00 00 00 01 00 00 | 00 33 50 52 4f 43 45 44 |el......|.3PROCED|
|00000720| 55 52 45 20 43 6c 69 63 | 6b 0d 0a 54 48 49 53 46 |URE Clic|k..THISF|
|00000730| 4f 52 4d 2e 4e 65 78 74 | 43 6f 6e 66 6c 69 63 74 |ORM.Next|Conflict|
|00000740| 0d 0a 0d 0a 45 4e 44 50 | 52 4f 43 0d 0a 00 00 00 |....ENDP|ROC.....|
|00000750| 01 00 00 00 0a 5f 63 6f | 6e 66 6c 69 63 74 73 00 |....._co|nflicts.|
|00000760| 00 00 01 00 00 00 7e 50 | 52 4f 43 45 44 55 52 45 |......~P|ROCEDURE|
|00000770| 20 43 6c 69 63 6b 0d 0a | 0d 0a 2a 21 2a 20 43 6c | Click..|..*!* Cl|
|00000780| 65 61 72 20 74 68 65 20 | 66 69 6c 74 65 72 20 74 |ear the |filter t|
|00000790| 68 61 74 20 77 61 73 20 | 73 65 74 0d 0a 53 45 54 |hat was |set..SET|
|000007a0| 20 46 49 4c 54 45 52 20 | 54 4f 0d 0a 47 4f 20 54 | FILTER |TO..GO T|
|000007b0| 4f 50 0d 0a 54 48 49 53 | 2e 65 6e 61 62 6c 65 64 |OP..THIS|.enabled|
|000007c0| 20 3d 20 2e 46 2e 0d 0a | 0d 0a 54 48 49 53 46 4f | = .F...|..THISFO|
|000007d0| 52 4d 2e 52 65 66 72 65 | 73 68 0d 0a 45 4e 44 50 |RM.Refre|sh..ENDP|
|000007e0| 52 4f 43 0d 0a 00 00 00 | 01 00 00 00 0e 5f 63 6f |ROC.....|....._co|
|000007f0| 6d 6d 61 6e 64 62 75 74 | 74 6f 6e 00 00 00 01 00 |mmandbut|ton.....|
|00000800| 00 00 0a 63 6d 64 51 42 | 46 4d 6f 64 65 00 00 00 |...cmdQB|FMode...|
|00000810| 01 00 00 00 0d 63 6f 6d | 6d 61 6e 64 62 75 74 74 |.....com|mandbutt|
|00000820| 6f 6e 00 00 00 01 00 00 | 00 09 5f 62 61 73 65 2e |on......|.._base.|
|00000830| 76 63 78 00 00 00 01 00 | 00 00 0e 5f 63 6f 6d 6d |vcx.....|..._comm|
|00000840| 61 6e 64 62 75 74 74 6f | 6e 00 00 00 01 00 00 00 |andbutto|n.......|
|00000850| 09 63 6f 6e 74 61 69 6e | 65 72 00 00 00 01 00 00 |.contain|er......|
|00000860| 00 01 31 00 00 00 01 00 | 00 00 07 5f 64 61 74 61 |..1.....|..._data|
|00000870| 2e 68 00 00 00 01 00 00 | 00 01 31 00 00 00 01 00 |.h......|..1.....|
|00000880| 00 00 ca 41 75 74 6f 53 | 69 7a 65 20 3d 20 2e 46 |...AutoS|ize = .F|
|00000890| 2e 0d 0a 54 6f 70 20 3d | 20 37 31 0d 0a 4c 65 66 |...Top =| 71..Lef|
|000008a0| 74 20 3d 20 34 0d 0a 48 | 65 69 67 68 74 20 3d 20 |t = 4..H|eight = |
|000008b0| 32 33 0d 0a 57 69 64 74 | 68 20 3d 20 37 32 0d 0a |23..Widt|h = 72..|
|000008c0| 46 6f 6e 74 42 6f 6c 64 | 20 3d 20 2e 46 2e 0d 0a |FontBold| = .F...|
|000008d0| 46 6f 6e 74 4e 61 6d 65 | 20 3d 20 22 4d 53 20 53 |FontName| = "MS S|
|000008e0| 61 6e 73 20 53 65 72 69 | 66 22 0d 0a 46 6f 6e 74 |ans Seri|f"..Font|
|000008f0| 53 69 7a 65 20 3d 20 38 | 0d 0a 43 61 70 74 69 6f |Size = 8|..Captio|
|00000900| 6e 20 3d 20 22 5c 3c 43 | 6c 65 61 72 20 46 69 6c |n = "\<C|lear Fil|
|00000910| 74 65 72 22 0d 0a 45 6e | 61 62 6c 65 64 20 3d 20 |ter"..En|abled = |
|00000920| 2e 46 2e 0d 0a 54 61 62 | 49 6e 64 65 78 20 3d 20 |.F...Tab|Index = |
|00000930| 32 35 0d 0a 4e 61 6d 65 | 20 3d 20 22 63 6d 64 43 |25..Name| = "cmdC|
|00000940| 6c 65 61 72 46 69 6c 74 | 65 72 22 0d 0a 00 00 00 |learFilt|er".....|
|00000950| 01 00 00 03 1e fe f2 ff | 20 02 01 00 00 00 05 03 |........| .......|
|00000960| 00 00 05 03 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 62 f3 01 00 |........|....b...|
|00000980| 00 00 25 00 00 00 7d 02 | 00 00 00 00 00 00 bc 02 |..%...}.|........|
|00000990| 00 00 18 00 00 00 8c 02 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 fc 03 00 03 00 55 | 00 00 ae 01 0f 00 ae f7 |.......U|........|
|000009b0| 00 00 07 f7 01 00 07 f7 | 02 00 fe 0d 00 54 f7 00 |........|.....T..|
|000009c0| 00 10 fc d9 00 00 fd fe | 1a 00 84 f7 01 00 10 fc |........|........|
|000009d0| f8 01 01 fd 28 fc f4 03 | 00 f7 04 00 fd f9 05 1b |....(...|........|
|000009e0| 01 fe 39 00 25 fc 43 fb | 25 00 54 48 49 53 46 4f |..9.%.C.|%.THISFO|
|000009f0| 52 4d 2e 43 6f 6e 74 72 | 6f 6c 73 28 6e 43 6e 74 |RM.Contr|ols(nCnt|
|00000a00| 29 2e 63 6f 6e 74 72 6f | 6c 53 6f 75 72 63 65 62 |).contro|lSourceb|
|00000a10| d9 01 00 55 0f fd f9 05 | 17 01 fe 46 00 25 fc 43 |...U....|...F.%.C|
|00000a20| 43 00 f7 01 00 f4 03 00 | e5 05 00 f7 06 00 a1 0a |C.......|........|
|00000a30| f0 28 00 43 fb 1d 00 54 | 48 49 53 46 4f 52 4d 2e |.(.C...T|HISFORM.|
|00000a40| 43 6f 6e 74 72 6f 6c 73 | 28 6e 43 6e 74 29 2e 76 |Controls|(nCnt).v|
|00000a50| 61 6c 75 65 62 d9 01 00 | 55 0f 09 fd f9 05 13 01 |alueb...|U.......|
|00000a60| fe 30 00 54 f7 02 00 10 | fc 43 43 00 f7 01 00 f4 |.0.T....|.CC.....|
|00000a70| 03 00 e5 05 00 f7 0a 00 | 43 00 f7 01 00 f4 03 00 |........|C.......|
|00000a80| e5 05 00 f7 06 00 f4 07 | 00 f4 08 00 f6 09 00 fd |........|........|
|00000a90| fe 10 00 25 fc 43 f7 02 | 00 a1 0a fd f9 05 0f 01 |...%.C..|........|
|00000aa0| fe 1a 00 54 f7 00 00 10 | fc f7 00 00 d9 05 00 20 |...T....|....... |
|00000ab0| 41 4e 44 20 06 f7 02 00 | 06 fd fe 04 00 1e fe 04 |AND ....|........|
|00000ac0| 00 1e fe 04 00 1e fe 04 | 00 85 fe 04 00 9c fe 0e |........|........|
|00000ad0| 00 54 f4 07 00 f7 0b 00 | 10 fc 2d fd fe 14 00 54 |.T......|..-....T|
|00000ae0| f4 07 00 f4 08 00 f4 0c | 00 f7 0b 00 10 fc 61 fd |........|......a.|
|00000af0| fe 10 00 25 fc 43 f7 00 | 00 a1 0a fd f9 05 6a 01 |...%.C..|......j.|
|00000b00| fe 15 00 54 f7 00 00 10 | fc 43 43 f7 00 00 f8 01 |...T....|.CC.....|
|00000b10| 05 ea b5 9b fd fe 04 00 | 1e fe 1a 00 01 53 45 54 |........|.....SET|
|00000b20| 20 46 49 4c 54 45 52 20 | 54 4f 20 26 63 46 69 6c | FILTER |TO &cFil|
|00000b30| 74 65 72 0a 14 00 54 f4 | 07 00 f4 08 00 f4 0d 00 |ter...T.|........|
|00000b40| f7 0b 00 10 fc 61 fd fe | 05 00 23 29 fe 0a 00 99 |.....a..|..#)....|
|00000b50| f4 03 00 f7 0e 00 fe 03 | 00 55 0f 00 07 00 43 46 |........|.U....CF|
|00000b60| 49 4c 54 45 52 04 00 4e | 43 4e 54 0a 00 43 43 4f |ILTER..N|CNT..CCO|
|00000b70| 4e 44 49 54 49 4f 4e 08 | 00 54 48 49 53 46 4f 52 |NDITION.|.THISFOR|
|00000b80| 4d 0c 00 43 4f 4e 54 52 | 4f 4c 43 4f 55 4e 54 08 |M..CONTR|OLCOUNT.|
|00000b90| 00 43 4f 4e 54 52 4f 4c | 53 0d 00 43 4f 4e 54 52 |.CONTROL|S..CONTR|
|00000ba0| 4f 4c 53 4f 55 52 43 45 | 04 00 54 48 49 53 06 00 |OLSOURCE|..THIS..|
|00000bb0| 50 41 52 45 4e 54 0e 00 | 50 41 52 53 45 43 4f 4e |PARENT..|PARSECON|
|00000bc0| 44 49 54 49 4f 4e 05 00 | 56 41 4c 55 45 07 00 45 |DITION..|VALUE..E|
|00000bd0| 4e 41 42 4c 45 44 0a 00 | 43 4d 44 51 42 46 4d 4f |NABLED..|CMDQBFMO|
|00000be0| 44 45 0e 00 43 4d 44 43 | 4c 45 41 52 46 49 4c 54 |DE..CMDC|LEARFILT|
|00000bf0| 45 52 07 00 52 45 46 52 | 45 53 48 05 00 43 6c 69 |ER..REFR|ESH..Cli|
|00000c00| 63 6b 2c 00 00 00 00 00 | ff ff 31 00 f1 00 d1 00 |ck,.....|..1.....|
|00000c10| a5 01 91 03 62 04 04 03 | 03 01 a1 01 41 00 41 00 |....b...|....A.A.|
|00000c20| 41 00 41 00 43 00 e2 00 | 41 01 04 01 51 01 41 00 |A.A.C...|A...Q.A.|
|00000c30| a3 01 42 01 52 00 a1 00 | 31 00 00 00 00 00 00 00 |..B.R...|1.......|
|00000c40| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 11 00 |........|........|
|00000c50| 00 00 22 05 00 00 01 00 | 00 00 00 29 00 00 00 05 |..".....|...)....|
|00000c60| 03 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c70| 00 00 00 00 00 00 01 00 | 00 00 b2 54 6f 70 20 3d |........|...Top =|
|00000c80| 20 33 31 0d 0a 4c 65 66 | 74 20 3d 20 34 0d 0a 48 | 31..Lef|t = 4..H|
|00000c90| 65 69 67 68 74 20 3d 20 | 32 33 0d 0a 57 69 64 74 |eight = |23..Widt|
|00000ca0| 68 20 3d 20 37 32 0d 0a | 46 6f 6e 74 42 6f 6c 64 |h = 72..|FontBold|
|00000cb0| 20 3d 20 2e 46 2e 0d 0a | 46 6f 6e 74 4e 61 6d 65 | = .F...|FontName|
|00000cc0| 20 3d 20 22 4d 53 20 53 | 61 6e 73 20 53 65 72 69 | = "MS S|ans Seri|
|00000cd0| 66 22 0d 0a 46 6f 6e 74 | 53 69 7a 65 20 3d 20 38 |f"..Font|Size = 8|
|00000ce0| 0d 0a 43 61 70 74 69 6f | 6e 20 3d 20 22 5c 3c 51 |..Captio|n = "\<Q|
|00000cf0| 75 65 72 79 22 0d 0a 45 | 6e 61 62 6c 65 64 20 3d |uery"..E|nabled =|
|00000d00| 20 2e 46 2e 0d 0a 54 61 | 62 49 6e 64 65 78 20 3d | .F...Ta|bIndex =|
|00000d10| 20 32 34 0d 0a 4e 61 6d | 65 20 3d 20 22 63 6d 64 | 24..Nam|e = "cmd|
|00000d20| 45 78 65 63 75 74 65 51 | 42 46 22 0d 0a 00 00 00 |ExecuteQ|BF".....|
|00000d30| 01 00 00 00 b3 41 75 74 | 6f 53 69 7a 65 20 3d 20 |.....Aut|oSize = |
|00000d40| 2e 46 2e 0d 0a 54 6f 70 | 20 3d 20 33 0d 0a 4c 65 |.F...Top| = 3..Le|
|00000d50| 66 74 20 3d 20 34 0d 0a | 48 65 69 67 68 74 20 3d |ft = 4..|Height =|
|00000d60| 20 32 33 0d 0a 57 69 64 | 74 68 20 3d 20 37 32 0d | 23..Wid|th = 72.|
|00000d70| 0a 46 6f 6e 74 42 6f 6c | 64 20 3d 20 2e 46 2e 0d |.FontBol|d = .F..|
|00000d80| 0a 46 6f 6e 74 4e 61 6d | 65 20 3d 20 22 4d 53 20 |.FontNam|e = "MS |
|00000d90| 53 61 6e 73 20 53 65 72 | 69 66 22 0d 0a 46 6f 6e |Sans Ser|if"..Fon|
|00000da0| 74 53 69 7a 65 20 3d 20 | 38 0d 0a 43 61 70 74 69 |tSize = |8..Capti|
|00000db0| 6f 6e 20 3d 20 22 5c 3c | 45 6e 74 65 72 20 51 42 |on = "\<|Enter QB|
|00000dc0| 46 22 0d 0a 54 61 62 49 | 6e 64 65 78 20 3d 20 32 |F"..TabI|ndex = 2|
|00000dd0| 33 0d 0a 4e 61 6d 65 20 | 3d 20 22 63 6d 64 51 42 |3..Name |= "cmdQB|
|00000de0| 46 4d 6f 64 65 22 0d 0a | 00 00 00 01 00 00 00 5a |FMode"..|.......Z|
|00000df0| 71 62 66 5f 74 61 62 6c | 65 20 53 70 65 63 69 66 |qbf_tabl|e Specif|
|00000e00| 69 65 73 20 74 68 65 20 | 74 61 62 6c 65 20 74 6f |ies the |table to|
|00000e10| 20 71 75 65 72 79 20 61 | 67 61 69 6e 73 74 2e 0d | query a|gainst..|
|00000e20| 0a 2a 70 61 72 73 65 63 | 6f 6e 64 69 74 69 6f 6e |.*parsec|ondition|
|00000e30| 20 46 69 6c 74 65 72 73 | 20 62 61 73 65 64 20 6f | Filters| based o|
|00000e40| 6e 20 71 75 65 72 79 2e | 0d 0a 00 00 00 01 00 00 |n query.|........|
|00000e50| 00 04 67 72 69 64 00 00 | 00 01 00 00 00 07 5f 64 |..grid..|......_d|
|00000e60| 61 74 61 2e 68 00 00 00 | 01 00 00 01 82 fe f2 ff |ata.h...|........|
|00000e70| 20 02 01 00 00 00 69 01 | 00 00 69 01 00 00 00 00 | .....i.|..i.....|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 ba 36 01 00 | 00 00 25 00 00 00 fb 00 |.....6..|..%.....|
|00000ea0| 00 00 00 00 00 00 20 01 | 00 00 0b 00 00 00 0a 01 |...... .|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 fc 03 00 03 00 55 |........|.......U|
|00000ec0| 00 00 77 00 16 00 25 fc | 43 f4 00 00 f4 01 00 f7 |..w...%.|C.......|
|00000ed0| 02 00 a1 0a fd f9 05 26 | 00 fe 10 00 46 fc f4 00 |.......&|....F...|
|00000ee0| 00 f4 01 00 f7 02 00 03 | fd fe 04 00 1e fe 05 00 |........|........|
|00000ef0| 9b bd fe 05 00 06 08 fe | 0e 00 54 f4 00 00 f7 03 |........|..T.....|
|00000f00| 00 10 fc 2d fd fe 14 00 | 54 f4 00 00 f4 01 00 f4 |...-....|T.......|
|00000f10| 04 00 f7 03 00 10 fc 61 | fd fe 14 00 54 f4 00 00 |.......a|....T...|
|00000f20| f4 01 00 f4 05 00 f7 03 | 00 10 fc 2d fd fe 0a 00 |........|...-....|
|00000f30| 99 f4 06 00 f7 07 00 fe | 03 00 55 08 00 04 00 54 |........|..U....T|
|00000f40| 48 49 53 06 00 50 41 52 | 45 4e 54 09 00 51 42 46 |HIS..PAR|ENT..QBF|
|00000f50| 5f 54 41 42 4c 45 07 00 | 45 4e 41 42 4c 45 44 0d |_TABLE..|ENABLED.|
|00000f60| 00 43 4d 44 45 58 45 43 | 55 54 45 51 42 46 0e 00 |.CMDEXEC|UTEQBF..|
|00000f70| 43 4d 44 43 4c 45 41 52 | 46 49 4c 54 45 52 08 00 |CMDCLEAR|FILTER..|
|00000f80| 54 48 49 53 46 4f 52 4d | 07 00 52 45 46 52 45 53 |THISFORM|..REFRES|
|00000f90| 48 05 00 43 6c 69 63 6b | 2c 00 00 00 00 00 ff ff |H..Click|,.......|
|00000fa0| 31 00 67 01 01 01 41 00 | 52 00 52 00 e2 00 42 01 |1.g...A.|R.R...B.|
|00000fb0| 41 01 a2 00 31 00 00 00 | 00 00 00 00 00 00 00 00 |A...1...|........|
|00000fc0| 00 00 00 00 00 00 01 00 | 00 00 11 00 00 00 f1 01 |........|........|
|00000fd0| 00 00 01 00 00 00 00 29 | 00 00 00 69 01 00 00 00 |.......)|...i....|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 01 00 00 01 fc 50 | 52 4f 43 45 44 55 52 45 |.......P|ROCEDURE|
|00001000| 20 43 6c 69 63 6b 0d 0a | 0d 0a 2a 21 2a 20 49 6e | Click..|..*!* In|
|00001010| 20 6f 72 64 65 72 20 74 | 6f 20 63 6c 65 61 72 20 | order t|o clear |
|00001020| 6f 75 74 20 61 6c 6c 20 | 74 68 65 20 63 6f 6e 74 |out all |the cont|
|00001030| 72 6f 6c 73 20 77 69 74 | 68 20 61 20 63 6f 6e 74 |rols wit|h a cont|
|00001040| 72 6f 6c 53 6f 75 72 63 | 65 2c 0d 0a 2a 21 2a 20 |rolSourc|e,..*!* |
|00001050| 77 65 20 6e 65 65 64 20 | 74 6f 20 73 74 61 72 74 |we need |to start|
|00001060| 20 61 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 20 61 | a trans|action a|
|00001070| 6e 64 20 61 70 70 65 6e | 64 20 61 20 72 65 63 6f |nd appen|d a reco|
|00001080| 72 64 20 28 74 68 65 6e | 20 77 68 65 6e 0d 0a 2a |rd (then| when..*|
|00001090| 21 2a 20 77 65 20 61 72 | 65 20 64 6f 6e 65 20 77 |!* we ar|e done w|
|000010a0| 65 27 6c 6c 20 72 6f 6c | 6c 62 61 63 6b 20 74 68 |e'll rol|lback th|
|000010b0| 65 20 74 72 61 6e 73 61 | 63 74 69 6f 6e 20 73 6f |e transa|ction so|
|000010c0| 20 74 68 65 20 6e 65 77 | 20 72 65 63 6f 72 64 0d | the new| record.|
|000010d0| 0a 2a 21 2a 20 64 6f 65 | 73 6e 27 74 20 67 65 74 |.*!* doe|sn't get|
|000010e0| 20 61 64 64 65 64 20 74 | 6f 20 74 68 65 20 74 61 | added t|o the ta|
|000010f0| 62 6c 65 0d 0a 0d 0a 49 | 46 20 21 45 4d 50 54 59 |ble....I|F !EMPTY|
|00001100| 28 54 48 49 53 2e 50 61 | 72 65 6e 74 2e 51 42 46 |(THIS.Pa|rent.QBF|
|00001110| 5f 74 61 62 6c 65 29 20 | 54 48 45 4e 0d 0a 09 53 |_table) |THEN...S|
|00001120| 45 4c 45 43 54 20 28 54 | 48 49 53 2e 50 61 72 65 |ELECT (T|HIS.Pare|
|00001130| 6e 74 2e 51 42 46 5f 74 | 61 62 6c 65 29 0d 0a 45 |nt.QBF_t|able)..E|
|00001140| 4e 44 49 46 0d 0a 0d 0a | 42 45 47 49 4e 20 54 52 |NDIF....|BEGIN TR|
|00001150| 41 4e 53 41 43 54 49 4f | 4e 0d 0a 0d 0a 41 50 50 |ANSACTIO|N....APP|
|00001160| 45 4e 44 20 42 4c 41 4e | 4b 0d 0a 0d 0a 54 48 49 |END BLAN|K....THI|
|00001170| 53 2e 45 6e 61 62 6c 65 | 64 20 3d 20 2e 46 2e 0d |S.Enable|d = .F..|
|00001180| 0a 0d 0a 54 48 49 53 2e | 50 61 72 65 6e 74 2e 63 |...THIS.|Parent.c|
|00001190| 6d 64 45 78 65 63 75 74 | 65 51 42 46 2e 45 6e 61 |mdExecut|eQBF.Ena|
|000011a0| 62 6c 65 64 20 3d 20 2e | 54 2e 0d 0a 54 48 49 53 |bled = .|T...THIS|
|000011b0| 2e 50 61 72 65 6e 74 2e | 63 6d 64 43 6c 65 61 72 |.Parent.|cmdClear|
|000011c0| 46 69 6c 74 65 72 2e 65 | 6e 61 62 6c 65 64 20 3d |Filter.e|nabled =|
|000011d0| 20 2e 46 2e 0d 0a 0d 0a | 54 48 49 53 46 4f 52 4d | .F.....|THISFORM|
|000011e0| 2e 52 65 66 72 65 73 68 | 0d 0a 45 4e 44 50 52 4f |.Refresh|..ENDPRO|
|000011f0| 43 0d 0a 00 00 00 01 00 | 00 00 56 57 69 64 74 68 |C.......|..VWidth|
|00001200| 20 3d 20 38 30 0d 0a 48 | 65 69 67 68 74 20 3d 20 | = 80..H|eight = |
|00001210| 39 37 0d 0a 42 61 63 6b | 53 74 79 6c 65 20 3d 20 |97..Back|Style = |
|00001220| 30 0d 0a 42 6f 72 64 65 | 72 57 69 64 74 68 20 3d |0..Borde|rWidth =|
|00001230| 20 30 0d 0a 71 62 66 5f | 74 61 62 6c 65 20 3d 20 | 0..qbf_|table = |
|00001240| 0d 0a 4e 61 6d 65 20 3d | 20 22 5f 71 62 66 22 0d |..Name =| "_qbf".|
|00001250| 0a 00 00 00 01 00 00 00 | 09 5f 62 61 73 65 2e 76 |........|._base.v|
|00001260| 63 78 00 00 00 01 00 00 | 00 0a 5f 63 6f 6e 74 61 |cx......|.._conta|
|00001270| 69 6e 65 72 00 00 00 01 | 00 00 00 07 63 6d 64 53 |iner....|....cmdS|
|00001280| 6b 69 70 00 00 00 01 00 | 00 00 0d 63 6f 6d 6d 61 |kip.....|...comma|
|00001290| 6e 64 62 75 74 74 6f 6e | 00 00 00 01 00 00 00 09 |ndbutton|........|
|000012a0| 5f 62 61 73 65 2e 76 63 | 78 00 00 00 01 00 00 00 |_base.vc|x.......|
|000012b0| 0e 5f 63 6f 6d 6d 61 6e | 64 62 75 74 74 6f 6e 00 |._comman|dbutton.|
|000012c0| 00 00 01 00 00 00 06 4c | 61 62 65 6c 33 00 00 00 |.......L|abel3...|
|000012d0| 01 00 00 00 11 01 00 07 | 00 5f 64 61 74 61 2e 68 |........|._data.h|
|000012e0| 12 81 fa 88 55 23 00 00 | 00 01 00 00 00 05 43 6c |....U#..|......Cl|
|000012f0| 61 73 73 00 00 00 01 00 | 00 00 01 32 00 00 00 01 |ass.....|...2....|
|00001300| 00 00 00 58 54 6f 70 20 | 3d 20 31 34 39 0d 0a 4c |...XTop |= 149..L|
|00001310| 65 66 74 20 3d 20 33 33 | 34 0d 0a 48 65 69 67 68 |eft = 33|4..Heigh|
|00001320| 74 20 3d 20 32 33 0d 0a | 57 69 64 74 68 20 3d 20 |t = 23..|Width = |
|00001330| 37 32 0d 0a 43 61 70 74 | 69 6f 6e 20 3d 20 22 5c |72..Capt|ion = "\|
|00001340| 3c 49 67 6e 6f 72 65 22 | 0d 0a 4e 61 6d 65 20 3d |<Ignore"|..Name =|
|00001350| 20 22 63 6d 64 53 6b 69 | 70 22 0d 0a 00 00 00 01 | "cmdSki|p"......|
|00001360| 00 00 00 0a 5f 63 6f 6e | 66 6c 69 63 74 73 00 00 |...._con|flicts..|
|00001370| 00 01 00 00 00 05 6c 61 | 62 65 6c 00 00 00 01 00 |......la|bel.....|
|00001380| 00 00 05 6c 61 62 65 6c | 00 00 00 01 00 00 00 0a |...label|........|
|00001390| 5f 63 6f 6e 66 6c 69 63 | 74 73 00 00 00 01 00 00 |_conflic|ts......|
|000013a0| 00 06 4c 61 62 65 6c 32 | 00 00 00 01 00 00 00 05 |..Label2|........|
|000013b0| 6c 61 62 65 6c 00 00 00 | 01 00 00 00 21 41 72 69 |label...|....!Ari|
|000013c0| 61 6c 2c 20 30 2c 20 39 | 2c 20 35 2c 20 31 35 2c |al, 0, 9|, 5, 15,|
|000013d0| 20 31 32 2c 20 32 31 2c | 20 33 2c 20 30 0a 00 00 | 12, 21,| 3, 0...|
|000013e0| 00 01 00 00 00 09 5f 62 | 61 73 65 2e 76 63 78 00 |......_b|ase.vcx.|
|000013f0| 00 00 01 00 00 00 08 5f | 6f 66 66 6c 69 6e 65 00 |......._|offline.|
|00001400| 00 00 01 00 00 00 cc fe | f2 ff 20 02 01 00 00 00 |........|.. .....|
|00001410| b3 00 00 00 b3 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 fd 2b |........|.......+|
|00001430| 01 00 00 00 25 00 00 00 | 55 00 00 00 00 00 00 00 |....%...|U.......|
|00001440| 6a 00 00 00 03 00 00 00 | 64 00 00 00 00 00 00 00 |j.......|d.......|
|00001450| 00 00 00 00 fc 03 00 03 | 00 55 00 00 0d 00 0a 00 |........|.U......|
|00001460| 99 f4 00 00 f7 01 00 fe | 03 00 55 02 00 08 00 54 |........|..U....T|
|00001470| 48 49 53 46 4f 52 4d 0c | 00 4e 45 58 54 43 4f 4e |HISFORM.|.NEXTCON|
|00001480| 46 4c 49 43 54 05 00 43 | 6c 69 63 6b 2c 00 00 00 |FLICT..C|lick,...|
|00001490| 00 00 ff ff 31 00 a1 00 | 32 00 00 00 00 00 00 00 |....1...|2.......|
|000014a0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 11 00 |........|........|
|000014b0| 00 00 28 00 00 00 01 00 | 00 00 00 29 00 00 00 b3 |..(.....|...)....|
|000014c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014d0| 00 00 00 00 00 00 01 00 | 00 00 56 43 61 70 74 69 |........|..VCapti|
|000014e0| 6f 6e 20 3d 20 22 4e 65 | 77 20 76 61 6c 75 65 22 |on = "Ne|w value"|
|000014f0| 0d 0a 48 65 69 67 68 74 | 20 3d 20 31 35 0d 0a 4c |..Height| = 15..L|
|00001500| 65 66 74 20 3d 20 38 0d | 0a 54 6f 70 20 3d 20 31 |eft = 8.|.Top = 1|
|00001510| 30 38 0d 0a 57 69 64 74 | 68 20 3d 20 38 34 0d 0a |08..Widt|h = 84..|
|00001520| 4e 61 6d 65 20 3d 20 22 | 4c 61 62 65 6c 33 22 0d |Name = "|Label3".|
|00001530| 0a 00 00 00 01 00 00 00 | 59 43 61 70 74 69 6f 6e |........|YCaption|
|00001540| 20 3d 20 22 43 75 72 72 | 65 6e 74 20 76 61 6c 75 | = "Curr|ent valu|
|00001550| 65 22 0d 0a 48 65 69 67 | 68 74 20 3d 20 31 35 0d |e"..Heig|ht = 15.|
|00001560| 0a 4c 65 66 74 20 3d 20 | 38 0d 0a 54 6f 70 20 3d |.Left = |8..Top =|
|00001570| 20 38 38 0d 0a 57 69 64 | 74 68 20 3d 20 39 36 0d | 88..Wid|th = 96.|
|00001580| 0a 4e 61 6d 65 20 3d 20 | 22 4c 61 62 65 6c 32 22 |.Name = |"Label2"|
|00001590| 0d 0a 00 00 00 01 00 00 | 00 05 6c 61 62 65 6c 00 |........|..label.|
|000015a0| 00 00 01 00 00 00 06 4c | 61 62 65 6c 31 00 00 00 |.......L|abel1...|
|000015b0| 01 00 00 00 01 31 00 00 | 00 01 00 00 00 29 4d 53 |.....1..|.....)MS|
|000015c0| 20 53 61 6e 73 20 53 65 | 72 69 66 2c 20 30 2c 20 | Sans Se|rif, 0, |
|000015d0| 38 2c 20 35 2c 20 31 33 | 2c 20 31 31 2c 20 31 31 |8, 5, 13|, 11, 11|
|000015e0| 2c 20 32 2c 20 30 0a 00 | 00 00 01 00 00 00 12 5f |, 2, 0..|......._|
|000015f0| 63 62 6f 64 69 73 74 69 | 6e 63 74 76 61 6c 75 65 |cbodisti|nctvalue|
|00001600| 73 00 00 00 01 00 00 00 | 06 50 69 78 65 6c 73 00 |s.......|.Pixels.|
|00001610| 00 00 01 00 00 00 05 43 | 6c 61 73 73 00 00 00 01 |.......C|lass....|
|00001620| 00 00 00 09 5f 63 6f 6d | 62 6f 62 6f 78 00 00 00 |...._com|bobox...|
|00001630| 01 00 00 00 12 5f 63 62 | 6f 64 69 73 74 69 6e 63 |....._cb|odistinc|
|00001640| 74 76 61 6c 75 65 73 00 | 00 00 01 00 00 00 08 63 |tvalues.|.......c|
|00001650| 6f 6d 62 6f 62 6f 78 00 | 00 00 01 00 00 00 09 5f |ombobox.|......._|
|00001660| 62 61 73 65 2e 76 63 78 | 00 00 00 01 00 00 00 55 |base.vcx|.......U|
|00001670| 43 61 70 74 69 6f 6e 20 | 3d 20 22 4f 6c 64 20 76 |Caption |= "Old v|
|00001680| 61 6c 75 65 22 0d 0a 48 | 65 69 67 68 74 20 3d 20 |alue"..H|eight = |
|00001690| 31 35 0d 0a 4c 65 66 74 | 20 3d 20 38 0d 0a 54 6f |15..Left| = 8..To|
|000016a0| 70 20 3d 20 36 38 0d 0a | 57 69 64 74 68 20 3d 20 |p = 68..|Width = |
|000016b0| 39 36 0d 0a 4e 61 6d 65 | 20 3d 20 22 4c 61 62 65 |96..Name| = "Labe|
|000016c0| 6c 31 22 0d 0a 00 00 00 | 01 00 00 00 0a 5f 63 6f |l1".....|....._co|
|000016d0| 6e 66 6c 69 63 74 73 00 | 00 00 01 00 00 00 05 6c |nflicts.|.......l|
|000016e0| 61 62 65 6c 00 00 00 01 | 00 00 00 05 6c 61 62 65 |abel....|....labe|
|000016f0| 6c 00 00 00 01 00 00 00 | 30 50 52 4f 43 45 44 55 |l.......|0PROCEDU|
|00001700| 52 45 20 43 6c 69 63 6b | 0d 0a 54 48 49 53 46 4f |RE Click|..THISFO|
|00001710| 52 4d 2e 72 65 6c 65 61 | 73 65 28 29 0d 0a 0d 0a |RM.relea|se()....|
|00001720| 45 4e 44 50 52 4f 43 0d | 0a 00 00 00 01 00 00 00 |ENDPROC.|........|
|00001730| 0a 5f 63 6f 6e 66 6c 69 | 63 74 73 00 00 00 01 00 |._confli|cts.....|
|00001740| 00 00 08 63 6d 64 43 6c | 6f 73 65 00 00 00 01 00 |...cmdCl|ose.....|
|00001750| 00 00 0d 63 6f 6d 6d 61 | 6e 64 62 75 74 74 6f 6e |...comma|ndbutton|
|00001760| 00 00 00 01 00 00 00 09 | 5f 62 61 73 65 2e 76 63 |........|_base.vc|
|00001770| 78 00 00 00 01 00 00 00 | 22 2e 2e 5c 73 61 6c 65 |x.......|"..\sale|
|00001780| 73 5c 67 72 61 70 68 69 | 63 73 5c 6f 66 66 6c 69 |s\graphi|cs\offli|
|00001790| 6e 65 5f 69 63 6f 6e 2e | 62 6d 70 00 00 00 01 00 |ne_icon.|bmp.....|
|000017a0| 00 00 22 2e 2e 5c 73 61 | 6c 65 73 5c 67 72 61 70 |.."..\sa|les\grap|
|000017b0| 68 69 63 73 5c 6f 66 66 | 6c 69 6e 65 5f 69 63 6f |hics\off|line_ico|
|000017c0| 6e 2e 62 6d 70 00 00 00 | 01 00 00 00 ab 46 6f 6e |n.bmp...|.....Fon|
|000017d0| 74 4e 61 6d 65 20 3d 20 | 22 4d 53 20 53 61 6e 73 |tName = |"MS Sans|
|000017e0| 20 53 65 72 69 66 22 0d | 0a 46 6f 6e 74 53 69 7a | Serif".|.FontSiz|
|000017f0| 65 20 3d 20 38 0d 0a 48 | 65 69 67 68 74 20 3d 20 |e = 8..H|eight = |
|00001800| 32 33 0d 0a 53 74 79 6c | 65 20 3d 20 32 0d 0a 57 |23..Styl|e = 2..W|
|00001810| 69 64 74 68 20 3d 20 31 | 37 35 0d 0a 64 69 73 70 |idth = 1|75..disp|
|00001820| 6c 61 79 5f 63 6f 6c 75 | 6d 6e 20 3d 20 0d 0a 6c |lay_colu|mn = ..l|
|00001830| 6f 6f 6b 75 70 5f 74 61 | 62 6c 65 20 3d 20 0d 0a |ookup_ta|ble = ..|
|00001840| 72 65 74 75 72 6e 5f 63 | 6f 6c 75 6d 6e 20 3d 20 |return_c|olumn = |
|00001850| 0d 0a 6f 72 64 65 72 5f | 63 6f 6c 75 6d 6e 20 3d |..order_|column =|
|00001860| 20 0d 0a 4e 61 6d 65 20 | 3d 20 22 5f 63 62 6f 6c | ..Name |= "_cbol|
|00001870| 6f 6f 6b 75 70 22 0d 0a | 00 00 00 01 00 00 00 0e |ookup"..|........|
|00001880| 5f 63 6f 6d 6d 61 6e 64 | 62 75 74 74 6f 6e 00 00 |_command|button..|
|00001890| 00 01 00 00 00 09 5f 62 | 61 73 65 2e 76 63 78 00 |......_b|ase.vcx.|
|000018a0| 00 00 01 00 00 00 08 63 | 6f 6d 62 6f 62 6f 78 00 |.......c|ombobox.|
|000018b0| 00 00 01 00 00 00 0a 5f | 63 62 6f 6c 6f 6f 6b 75 |......._|cbolooku|
|000018c0| 70 00 00 00 01 00 00 00 | 09 5f 63 6f 6d 62 6f 62 |p.......|._combob|
|000018d0| 6f 78 00 00 00 01 00 00 | 00 05 43 6c 61 73 73 00 |ox......|..Class.|
|000018e0| 00 00 01 00 00 00 06 50 | 69 78 65 6c 73 00 00 00 |.......P|ixels...|
|000018f0| 01 00 00 00 07 5f 64 61 | 74 61 2e 68 00 00 00 01 |....._da|ta.h....|
|00001900| 00 00 00 83 50 52 4f 43 | 45 44 55 52 45 20 4f 70 |....PROC|EDURE Op|
|00001910| 74 69 6f 6e 31 2e 43 6c | 69 63 6b 0d 0a 54 48 49 |tion1.Cl|ick..THI|
|00001920| 53 2e 50 61 72 65 6e 74 | 2e 50 61 72 65 6e 74 2e |S.Parent|.Parent.|
|00001930| 47 6f 4f 6e 6c 69 6e 65 | 28 29 0d 0a 45 4e 44 50 |GoOnline|()..ENDP|
|00001940| 52 4f 43 0d 0a 50 52 4f | 43 45 44 55 52 45 20 4f |ROC..PRO|CEDURE O|
|00001950| 70 74 69 6f 6e 32 2e 43 | 6c 69 63 6b 0d 0a 54 48 |ption2.C|lick..TH|
|00001960| 49 53 2e 50 61 72 65 6e | 74 2e 50 61 72 65 6e 74 |IS.Paren|t.Parent|
|00001970| 2e 47 6f 4f 66 66 6c 69 | 6e 65 28 29 0d 0a 45 4e |.GoOffli|ne()..EN|
|00001980| 44 50 52 4f 43 0d 0a 00 | 00 00 01 00 00 02 02 41 |DPROC...|.......A|
|00001990| 75 74 6f 53 69 7a 65 20 | 3d 20 2e 46 2e 0d 0a 42 |utoSize |= .F...B|
|000019a0| 75 74 74 6f 6e 43 6f 75 | 6e 74 20 3d 20 32 0d 0a |uttonCou|nt = 2..|
|000019b0| 42 6f 72 64 65 72 53 74 | 79 6c 65 20 3d 20 30 0d |BorderSt|yle = 0.|
|000019c0| 0a 56 61 6c 75 65 20 3d | 20 31 0d 0a 48 65 69 67 |.Value =| 1..Heig|
|000019d0| 68 74 20 3d 20 36 32 0d | 0a 54 6f 70 20 3d 20 33 |ht = 62.|.Top = 3|
|000019e0| 0d 0a 57 69 64 74 68 20 | 3d 20 31 32 32 0d 0a 4e |..Width |= 122..N|
|000019f0| 61 6d 65 20 3d 20 22 6f | 67 4f 66 66 6c 69 6e 65 |ame = "o|gOffline|
|00001a00| 22 0d 0a 4f 70 74 69 6f | 6e 31 2e 50 69 63 74 75 |"..Optio|n1.Pictu|
|00001a10| 72 65 20 3d 20 67 72 61 | 70 68 69 63 73 5c 6f 6e |re = gra|phics\on|
|00001a20| 6c 69 6e 65 2e 69 63 6f | 0d 0a 4f 70 74 69 6f 6e |line.ico|..Option|
|00001a30| 31 2e 43 61 70 74 69 6f | 6e 20 3d 20 22 4f 6e 6c |1.Captio|n = "Onl|
|00001a40| 69 6e 65 22 0d 0a 4f 70 | 74 69 6f 6e 31 2e 56 61 |ine"..Op|tion1.Va|
|00001a50| 6c 75 65 20 3d 20 31 0d | 0a 4f 70 74 69 6f 6e 31 |lue = 1.|.Option1|
|00001a60| 2e 48 65 69 67 68 74 20 | 3d 20 35 39 0d 0a 4f 70 |.Height |= 59..Op|
|00001a70| 74 69 6f 6e 31 2e 4c 65 | 66 74 20 3d 20 35 0d 0a |tion1.Le|ft = 5..|
|00001a80| 4f 70 74 69 6f 6e 31 2e | 53 74 79 6c 65 20 3d 20 |Option1.|Style = |
|00001a90| 31 0d 0a 4f 70 74 69 6f | 6e 31 2e 54 6f 70 20 3d |1..Optio|n1.Top =|
|00001aa0| 20 30 0d 0a 4f 70 74 69 | 6f 6e 31 2e 57 69 64 74 | 0..Opti|on1.Widt|
|00001ab0| 68 20 3d 20 35 35 0d 0a | 4f 70 74 69 6f 6e 31 2e |h = 55..|Option1.|
|00001ac0| 4e 61 6d 65 20 3d 20 22 | 4f 70 74 69 6f 6e 31 22 |Name = "|Option1"|
|00001ad0| 0d 0a 4f 70 74 69 6f 6e | 32 2e 50 69 63 74 75 72 |..Option|2.Pictur|
|00001ae0| 65 20 3d 20 67 72 61 70 | 68 69 63 73 5c 6f 66 66 |e = grap|hics\off|
|00001af0| 6c 69 6e 65 2e 69 63 6f | 0d 0a 4f 70 74 69 6f 6e |line.ico|..Option|
|00001b00| 32 2e 43 61 70 74 69 6f | 6e 20 3d 20 22 4f 66 66 |2.Captio|n = "Off|
|00001b10| 6c 69 6e 65 22 0d 0a 4f | 70 74 69 6f 6e 32 2e 48 |line"..O|ption2.H|
|00001b20| 65 69 67 68 74 20 3d 20 | 35 39 0d 0a 4f 70 74 69 |eight = |59..Opti|
|00001b30| 6f 6e 32 2e 4c 65 66 74 | 20 3d 20 36 34 0d 0a 4f |on2.Left| = 64..O|
|00001b40| 70 74 69 6f 6e 32 2e 53 | 74 79 6c 65 20 3d 20 31 |ption2.S|tyle = 1|
|00001b50| 0d 0a 4f 70 74 69 6f 6e | 32 2e 54 6f 70 20 3d 20 |..Option|2.Top = |
|00001b60| 30 0d 0a 4f 70 74 69 6f | 6e 32 2e 57 69 64 74 68 |0..Optio|n2.Width|
|00001b70| 20 3d 20 35 35 0d 0a 4f | 70 74 69 6f 6e 32 2e 4e | = 55..O|ption2.N|
|00001b80| 61 6d 65 20 3d 20 22 4f | 70 74 69 6f 6e 32 22 0d |ame = "O|ption2".|
|00001b90| 0a 00 00 00 01 00 00 00 | 08 5f 6f 66 66 6c 69 6e |........|._offlin|
|00001ba0| 65 00 00 00 01 00 00 00 | 09 6f 67 4f 66 66 6c 69 |e.......|.ogOffli|
|00001bb0| 6e 65 00 00 00 01 00 00 | 00 0b 6f 70 74 69 6f 6e |ne......|..option|
|00001bc0| 67 72 6f 75 70 00 00 00 | 01 00 00 00 0b 6f 70 74 |group...|.....opt|
|00001bd0| 69 6f 6e 67 72 6f 75 70 | 00 00 00 01 00 00 02 4f |iongroup|.......O|
|00001be0| 63 64 61 74 61 62 61 73 | 65 20 4e 61 6d 65 20 6f |cdatabas|e Name o|
|00001bf0| 66 20 64 61 74 61 62 61 | 73 65 20 63 6f 6e 74 61 |f databa|se conta|
|00001c00| 69 6e 69 6e 67 20 76 69 | 65 77 73 20 74 6f 20 74 |ining vi|ews to t|
|00001c10| 61 6b 65 20 6f 66 66 6c | 69 6e 65 2e 0d 0a 6c 72 |ake offl|ine...lr|
|00001c20| 65 76 65 72 74 6f 6e 66 | 61 69 6c 20 57 68 65 74 |evertonf|ail Whet|
|00001c30| 68 65 72 20 74 6f 20 72 | 65 76 65 72 74 20 61 6c |her to r|evert al|
|00001c40| 6c 20 76 69 65 77 73 20 | 69 66 20 6f 6e 65 20 66 |l views |if one f|
|00001c50| 61 69 6c 73 20 77 68 65 | 6e 20 67 6f 69 6e 67 20 |ails whe|n going |
|00001c60| 6f 66 66 6c 69 6e 65 2e | 0d 0a 6c 75 70 64 61 74 |offline.|..lupdat|
|00001c70| 65 76 69 65 77 73 20 57 | 68 65 74 68 65 72 20 74 |eviews W|hether t|
|00001c80| 6f 20 75 70 64 61 74 65 | 20 61 6c 6c 20 76 69 65 |o update| all vie|
|00001c90| 77 73 20 77 68 65 6e 20 | 67 6f 69 6e 67 20 6f 6e |ws when |going on|
|00001ca0| 6c 69 6e 65 2e 0d 0a 6c | 61 6c 6c 76 69 65 77 73 |line...l|allviews|
|00001cb0| 20 57 68 65 74 68 65 72 | 20 74 6f 20 61 75 74 6f | Whether| to auto|
|00001cc0| 6d 61 74 69 63 61 6c 6c | 79 20 75 73 65 20 61 6c |maticall|y use al|
|00001cd0| 6c 20 76 69 65 77 73 20 | 69 6e 20 64 61 74 61 62 |l views |in datab|
|00001ce0| 61 73 65 2e 0d 0a 6c 75 | 73 65 63 75 72 72 65 6e |ase...lu|securren|
|00001cf0| 74 64 62 63 20 57 68 65 | 74 68 65 72 20 74 6f 20 |tdbc Whe|ther to |
|00001d00| 75 73 65 20 63 75 72 72 | 65 6e 74 6c 79 20 6f 70 |use curr|ently op|
|00001d10| 65 6e 65 64 20 64 61 74 | 61 62 61 73 65 20 61 74 |ened dat|abase at|
|00001d20| 20 73 74 61 72 74 2e 0d | 0a 2a 67 6f 6f 66 66 6c | start..|.*gooffl|
|00001d30| 69 6e 65 20 54 61 6b 65 | 73 20 73 70 65 63 69 66 |ine Take|s specif|
|00001d40| 69 65 64 20 76 69 65 77 | 73 20 6f 66 66 6c 69 6e |ied view|s offlin|
|00001d50| 65 2e 0d 0a 2a 67 6f 6f | 6e 6c 69 6e 65 20 54 61 |e...*goo|nline Ta|
|00001d60| 6b 65 73 20 73 70 65 63 | 69 66 69 65 64 20 76 69 |kes spec|ified vi|
|00001d70| 65 77 73 20 6f 6e 6c 69 | 6e 65 0d 0a 2a 63 68 65 |ews onli|ne..*che|
|00001d80| 63 6b 6f 66 66 6c 69 6e | 65 20 43 68 65 63 6b 73 |ckofflin|e Checks|
|00001d90| 20 74 6f 20 73 65 65 20 | 69 66 20 76 69 65 77 73 | to see |if views|
|00001da0| 20 61 72 65 20 63 75 72 | 72 65 6e 74 6c 79 20 6f | are cur|rently o|
|00001db0| 6e 6c 69 6e 65 2f 6f 66 | 66 6c 69 6e 65 2e 0d 0a |nline/of|fline...|
|00001dc0| 2a 61 6c 65 72 74 20 44 | 69 73 70 6c 61 79 73 20 |*alert D|isplays |
|00001dd0| 6d 65 73 73 61 67 65 62 | 6f 78 20 64 69 61 6c 6f |messageb|ox dialo|
|00001de0| 67 2e 0d 0a 5e 61 75 70 | 64 61 74 65 65 72 72 6f |g...^aup|dateerro|
|00001df0| 72 73 5b 31 2c 30 5d 20 | 0d 0a 5e 63 76 69 65 77 |rs[1,0] |..^cview|
|00001e00| 73 5b 31 2c 30 5d 20 41 | 72 72 61 79 20 6f 66 20 |s[1,0] A|rray of |
|00001e10| 76 69 65 77 73 20 74 6f | 20 70 72 6f 63 65 73 73 |views to| process|
|00001e20| 2e 0d 0a 2a 73 65 74 76 | 69 65 77 73 20 0d 0a 00 |...*setv|iews ...|
|00001e30| 00 00 01 00 00 0c 3d fe | f2 ff 20 02 01 00 00 00 |......=.|.. .....|
|00001e40| 24 0c 00 00 24 0c 00 00 | 00 00 00 00 00 00 00 00 |$...$...|........|
|00001e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 7e 40 |........|......~@|
|00001e60| 06 00 00 00 25 00 00 00 | 2d 0a 00 00 00 00 00 00 |....%...|-.......|
|00001e70| 8b 0b 00 00 7a 00 00 00 | 97 0a 00 00 00 00 00 00 |....z...|........|
|00001e80| 00 00 00 00 fc 03 00 03 | 00 55 00 00 f0 01 0b 00 |........|.U......|
|00001e90| ae f7 00 00 07 f7 01 00 | fe 2c 00 25 fc 43 f4 02 |........|.,.%.C..|
|00001ea0| 00 f7 03 00 a1 0a f0 16 | 00 43 d9 08 00 44 41 54 |........|.C...DAT|
|00001eb0| 41 42 41 53 45 76 f4 02 | 00 f7 03 00 0f 03 09 fd |ABASEv..|........|
|00001ec0| f9 05 46 00 fe 0f 00 47 | 7f 28 fc f4 02 00 f7 03 |..F....G|.(......|
|00001ed0| 00 03 fd fe 04 00 1e fe | 16 00 25 fc 43 43 f8 01 |........|..%.CC..|
|00001ee0| 01 f4 02 00 f6 04 00 a1 | fd f9 05 9a 00 fe 33 00 |........|......3.|
|00001ef0| 99 fc 43 d9 23 00 4e 6f | 20 76 69 65 77 73 20 73 |..C.#.No| views s|
|00001f00| 70 65 63 69 66 69 65 64 | 20 74 6f 20 74 61 6b 65 |pecified| to take|
|00001f10| 20 6f 66 66 6c 69 6e 65 | 2e f4 02 00 f6 05 00 fd | offline|........|
|00001f20| fe 07 00 42 fc 2d fd fe | 04 00 1e fe 1c 00 84 f7 |...B.-..|........|
|00001f30| 00 00 10 fc f8 01 01 fd | 28 fc 43 f4 02 00 e0 04 |........|(.C.....|
|00001f40| 00 cd fd f9 05 b4 01 fe | 2b 00 25 fc 43 43 00 f5 |........|+.%.CC..|
|00001f50| 0d f7 00 00 f4 02 00 f6 | 04 00 d9 04 00 56 49 45 |........|.....VIE|
|00001f60| 57 d9 07 00 4f 46 46 4c | 49 4e 45 ea 8b fd f9 05 |W...OFFL|INE.....|
|00001f70| e9 00 fe 04 00 2e fe 04 | 00 1e fe 1b 00 25 fc 43 |........|.....%.C|
|00001f80| 43 00 f5 0d f7 00 00 f4 | 02 00 f6 04 00 ea c7 0a |C.......|........|
|00001f90| fd f9 05 b0 01 fe 45 00 | 99 fc 43 d9 27 00 46 61 |......E.|..C.'.Fa|
|00001fa0| 69 6c 65 64 20 74 6f 20 | 74 61 6b 65 20 66 6f 6c |iled to |take fol|
|00001fb0| 6c 6f 77 69 6e 67 20 76 | 69 65 77 20 6f 66 66 6c |lowing v|iew offl|
|00001fc0| 69 6e 65 3a 20 43 00 f5 | 0d f7 00 00 f4 02 00 f6 |ine: C..|........|
|00001fd0| 04 00 06 f4 02 00 f6 05 | 00 fd fe 10 00 25 fc f4 |........|.....%..|
|00001fe0| 02 00 f7 06 00 fd f9 05 | ac 01 fe 1b 00 84 f7 01 |........|........|
|00001ff0| 00 10 fc f8 01 01 fd 28 | fc f7 00 00 f8 01 01 08 |.......(|........|
|00002000| fd f9 05 8e 01 fe 16 00 | 99 fc 43 43 00 f5 0d f7 |........|..CC....|
|00002010| 00 00 f4 02 00 f6 04 00 | ea c8 fd fe 04 00 85 fe |........|........|
|00002020| 13 00 54 f4 02 00 f4 07 | 00 f7 08 00 10 fc f8 01 |..T.....|........|
|00002030| 01 fd fe 07 00 42 fc 2d | fd fe 04 00 1e fe 04 00 |.....B.-|........|
|00002040| 1e fe 04 00 85 fe 35 00 | 99 fc 43 d9 25 00 56 69 |......5.|..C.%.Vi|
|00002050| 65 77 20 77 65 72 65 20 | 73 75 63 63 65 73 73 66 |ew were |successf|
|00002060| 75 6c 6c 79 20 74 61 6b | 65 6e 20 6f 66 66 6c 69 |ully tak|en offli|
|00002070| 6e 65 2e f4 02 00 f6 05 | 00 fd fe 03 00 55 09 00 |ne......|.....U..|
|00002080| 01 00 49 01 00 4a 04 00 | 54 48 49 53 09 00 43 44 |..I..J..|THIS..CD|
|00002090| 41 54 41 42 41 53 45 06 | 00 43 56 49 45 57 53 05 |ATABASE.|.CVIEWS.|
|000020a0| 00 41 4c 45 52 54 0d 00 | 4c 52 45 56 45 52 54 4f |.ALERT..|LREVERTO|
|000020b0| 4e 46 41 49 4c 09 00 4f | 47 4f 46 46 4c 49 4e 45 |NFAIL..O|GOFFLINE|
|000020c0| 05 00 56 41 4c 55 45 d4 | 03 25 00 ae f7 00 00 07 |..VALUE.|.%......|
|000020d0| f7 01 00 07 f6 02 00 fc | f8 01 01 fd 16 07 f7 03 |........|........|
|000020e0| 00 07 f7 04 00 07 f7 05 | 00 07 f7 06 00 fe 0b 00 |........|........|
|000020f0| 54 f7 04 00 10 fc 2d fd | fe 10 00 15 f4 07 00 f6 |T.....-.|........|
|00002100| 02 00 fc f8 01 01 fd 16 | fe 16 00 54 f4 07 00 f6 |........|...T....|
|00002110| 02 00 fc f8 01 01 fd 16 | 10 fc f8 01 00 fd fe 2c |........|.......,|
|00002120| 00 25 fc 43 f4 07 00 f7 | 08 00 a1 0a f0 16 00 43 |.%.C....|.......C|
|00002130| d9 08 00 44 41 54 41 42 | 41 53 45 76 f4 07 00 f7 |...DATAB|ASEv....|
|00002140| 08 00 0f 03 09 fd f9 05 | 91 00 fe 0f 00 47 7f 28 |........|.....G.(|
|00002150| fc f4 07 00 f7 08 00 03 | fd fe 04 00 1e fe 16 00 |........|........|
|00002160| 25 fc 43 43 f8 01 01 f4 | 07 00 f6 09 00 a1 fd f9 |%.CC....|........|
|00002170| 05 e2 00 fe 33 00 99 fc | 43 d9 23 00 4e 6f 20 76 |....3...|C.#.No v|
|00002180| 69 65 77 73 20 73 70 65 | 63 69 66 69 65 64 20 74 |iews spe|cified t|
|00002190| 6f 20 74 61 6b 65 20 6f | 66 66 6c 69 6e 65 2e f4 |o take o|ffline..|
|000021a0| 07 00 f6 0a 00 fd fe 04 | 00 42 fe 04 00 1e fe 0c |........|.B......|
|000021b0| 00 54 f7 06 00 10 fc 43 | 57 fd fe 1c 00 84 f7 03 |.T.....C|W.......|
|000021c0| 00 10 fc f8 01 01 fd 28 | fc 43 f4 07 00 e0 09 00 |.......(|.C......|
|000021d0| cd fd f9 05 5f 03 fe 2c | 00 25 fc 43 43 00 f5 0d |...._..,|.%.CC...|
|000021e0| f7 03 00 f4 07 00 f6 09 | 00 d9 04 00 56 49 45 57 |........|....VIEW|
|000021f0| d9 07 00 4f 46 46 4c 49 | 4e 45 ea 8b 0a fd f9 05 |...OFFLI|NE......|
|00002200| 3e 01 fe 04 00 2e fe 04 | 00 1e fe 10 00 25 fc f4 |>.......|.....%..|
|00002210| 07 00 f7 0b 00 fd f9 05 | c1 02 fe 19 00 54 f7 05 |........|.....T..|
|00002220| 00 10 fc 43 43 00 f5 0d | f7 03 00 f4 07 00 f6 09 |...CC...|........|
|00002230| 00 aa fd fe 0f 00 25 fc | f5 0d f7 05 00 fd f9 05 |......%.|........|
|00002240| 8e 01 fe 14 00 46 fc 43 | 00 f5 0d f7 03 00 f4 07 |.....F.C|........|
|00002250| 00 f6 09 00 03 fd fe 08 | 00 1b f9 05 9e 01 fe 08 |........|........|
|00002260| 00 46 f9 01 00 00 fe 04 | 00 1e fe 16 00 51 bc fc |.F......|.....Q..|
|00002270| 43 00 f5 0d f7 03 00 f4 | 07 00 f6 09 00 03 fd d6 |C.......|........|
|00002280| fe 0e 00 25 fc 43 43 1b | a1 fd f9 05 0e 02 fe 39 |...%.CC.|.......9|
|00002290| 00 99 fc 43 d9 1f 00 43 | 6f 75 6c 64 20 6e 6f 74 |...C...C|ould not|
|000022a0| 20 6f 70 65 6e 20 66 6f | 6c 6c 6f 77 69 6e 67 20 | open fo|llowing |
|000022b0| 76 69 65 77 3a 20 43 00 | f5 0d f7 03 00 f4 07 00 |view: C.|........|
|000022c0| f6 09 00 06 ea 78 fd fe | 0b 00 54 f7 04 00 10 fc |.....x..|..T.....|
|000022d0| 61 fd fe 04 00 21 fe 04 | 00 1e fe 13 00 54 f7 00 |a....!..|.....T..|
|000022e0| 00 10 fc 43 f8 01 02 f7 | 02 00 ea 93 fd fe 15 00 |...C....|........|
|000022f0| 51 16 fc 43 00 f5 0d f7 | 03 00 f4 07 00 f6 09 00 |Q..C....|........|
|00002300| 03 fd fe 10 00 25 fc f5 | 0d f7 00 00 0a fd f9 05 |.....%..|........|
|00002310| bd 02 fe 13 00 99 fc 43 | eb f7 02 00 f4 07 00 e0 |.......C|........|
|00002320| 02 00 ea 0d fd fe 51 00 | 99 fc 43 d9 37 00 41 20 |......Q.|..C.7.A |
|00002330| 72 65 63 6f 72 64 20 63 | 6f 6e 66 6c 69 63 74 20 |record c|onflict |
|00002340| 6f 63 63 75 72 65 64 20 | 64 75 72 69 6e 67 20 74 |occured |during t|
|00002350| 68 65 20 75 70 64 61 74 | 65 20 77 69 74 68 20 76 |he updat|e with v|
|00002360| 69 65 77 3a 20 43 00 f5 | 0d f7 03 00 f4 07 00 f6 |iew: C..|........|
|00002370| 09 00 06 ea 78 fd fe 0b | 00 54 f7 04 00 10 fc 61 |....x...|.T.....a|
|00002380| fd fe 04 00 21 fe 04 00 | 1e fe 04 00 1e fe 1a 00 |....!...|........|
|00002390| 54 f7 01 00 10 fc 43 43 | 00 f5 0d f7 03 00 f4 07 |T.....CC|........|
|000023a0| 00 f6 09 00 ea c8 fd fe | 0f 00 25 fc f5 0d f7 05 |........|..%.....|
|000023b0| 00 fd f9 05 02 03 fe 14 | 00 51 fc 43 00 f5 0d f7 |........|.Q.C....|
|000023c0| 03 00 f4 07 00 f6 09 00 | 03 fd fe 04 00 1e fe 10 |........|........|
|000023d0| 00 25 fc f5 0d f7 01 00 | 0a fd f9 05 5b 03 fe 36 |.%......|....[..6|
|000023e0| 00 99 fc 43 d9 1c 00 46 | 61 69 6c 65 64 20 74 6f |...C...F|ailed to|
|000023f0| 20 74 61 6b 65 20 6f 6e | 6c 69 6e 65 20 76 69 65 | take on|line vie|
|00002400| 77 3a 20 43 00 f5 0d f7 | 03 00 f4 07 00 f6 09 00 |w: C....|........|
|00002410| 06 ea 78 fd fe 0b 00 54 | f7 04 00 10 fc 61 fd fe |..x....T|.....a..|
|00002420| 04 00 21 fe 04 00 1e fe | 04 00 85 fe 0f 00 25 fc |..!.....|......%.|
|00002430| f5 0d f7 04 00 fd f9 05 | 85 03 fe 13 00 54 f4 07 |........|.....T..|
|00002440| 00 f4 0c 00 f7 0d 00 10 | fc f8 01 02 fd fe 08 00 |........|........|
|00002450| 1b f9 05 c1 03 fe 34 00 | 99 fc 43 d9 24 00 56 69 |......4.|..C.$.Vi|
|00002460| 65 77 20 77 65 72 65 20 | 73 75 63 63 65 73 73 66 |ew were |successf|
|00002470| 75 6c 6c 79 20 74 61 6b | 65 6e 20 6f 6e 6c 69 6e |ully tak|en onlin|
|00002480| 65 2e f4 07 00 f6 0a 00 | fd fe 04 00 1e fe 0c 00 |e.......|........|
|00002490| 46 fc f5 0d f7 06 00 03 | fd fe 03 00 55 0e 00 0e |F.......|....U...|
|000024a0| 00 4c 55 50 44 41 54 45 | 53 55 43 43 45 53 53 0c |.LUPDATE|SUCCESS.|
|000024b0| 00 4c 44 52 4f 50 53 55 | 43 43 45 53 53 0d 00 41 |.LDROPSU|CCESS..A|
|000024c0| 55 50 44 41 54 45 45 52 | 52 4f 52 53 01 00 49 06 |UPDATEER|RORS..I.|
|000024d0| 00 4c 41 42 4f 52 54 0c | 00 4c 41 4c 52 45 41 44 |.LABORT.|.LALREAD|
|000024e0| 59 55 53 45 44 09 00 4e | 53 41 56 45 41 52 45 41 |YUSED..N|SAVEAREA|
|000024f0| 04 00 54 48 49 53 09 00 | 43 44 41 54 41 42 41 53 |..THIS..|CDATABAS|
|00002500| 45 06 00 43 56 49 45 57 | 53 05 00 41 4c 45 52 54 |E..CVIEW|S..ALERT|
|00002510| 0c 00 4c 55 50 44 41 54 | 45 56 49 45 57 53 09 00 |..LUPDAT|EVIEWS..|
|00002520| 4f 47 4f 46 46 4c 49 4e | 45 05 00 56 41 4c 55 45 |OGOFFLIN|E..VALUE|
|00002530| 4b 01 0b 00 ae f7 00 00 | 07 f7 01 00 fe 2c 00 25 |K.......|.....,.%|
|00002540| fc 43 f4 02 00 f7 03 00 | a1 0a f0 16 00 43 d9 08 |.C......|.....C..|
|00002550| 00 44 41 54 41 42 41 53 | 45 76 f4 02 00 f7 03 00 |.DATABAS|Ev......|
|00002560| 0f 03 09 fd f9 05 46 00 | fe 0f 00 47 7f 28 fc f4 |......F.|...G.(..|
|00002570| 02 00 f7 03 00 03 fd fe | 04 00 1e fe 22 00 25 fc |........|....".%.|
|00002580| 43 f4 02 00 f7 03 00 a1 | f1 0d 00 43 43 f8 01 01 |C.......|...CC...|
|00002590| f4 02 00 f6 04 00 a1 0b | fd f9 05 98 00 fe 14 00 |........|........|
|000025a0| 54 f4 02 00 f4 05 00 f4 | 06 00 f7 07 00 10 fc 2d |T.......|.......-|
|000025b0| fd fe 14 00 54 f4 02 00 | f4 05 00 f4 08 00 f7 07 |....T...|........|
|000025c0| 00 10 fc 2d fd fe 04 00 | 42 fe 04 00 1e fe 14 00 |...-....|B.......|
|000025d0| 54 f4 02 00 f4 05 00 f4 | 06 00 f7 07 00 10 fc 61 |T.......|.......a|
|000025e0| fd fe 14 00 54 f4 02 00 | f4 05 00 f4 08 00 f7 07 |....T...|........|
|000025f0| 00 10 fc 61 fd fe 1c 00 | 84 f7 01 00 10 fc f8 01 |...a....|........|
|00002600| 01 fd 28 fc 43 f4 02 00 | e0 04 00 cd fd f9 05 21 |..(.C...|.......!|
|00002610| 01 fe 2b 00 54 f7 00 00 | 10 fc 43 43 00 f5 0d f7 |..+.T...|..CC....|
|00002620| 01 00 f4 02 00 f6 04 00 | d9 04 00 56 49 45 57 d9 |........|...VIEW.|
|00002630| 07 00 4f 46 46 4c 49 4e | 45 ea 8b fd fe 0e 00 25 |..OFFLIN|E......%|
|00002640| fc f7 00 00 0a fd f9 05 | 1d 01 fe 04 00 21 fe 04 |........|.....!..|
|00002650| 00 1e fe 04 00 85 fe 23 | 00 54 f4 02 00 f4 05 00 |.......#|.T......|
|00002660| f7 09 00 10 fc 43 f5 0d | f7 00 00 f2 06 00 f8 01 |.....C..|........|
|00002670| 02 f3 03 00 f8 01 01 36 | fd fe 03 00 55 0a 00 08 |.......6|....U...|
|00002680| 00 4c 4f 46 46 4c 49 4e | 45 01 00 49 04 00 54 48 |.LOFFLIN|E..I..TH|
|00002690| 49 53 09 00 43 44 41 54 | 41 42 41 53 45 06 00 43 |IS..CDAT|ABASE..C|
|000026a0| 56 49 45 57 53 09 00 4f | 47 4f 46 46 4c 49 4e 45 |VIEWS..O|GOFFLINE|
|000026b0| 07 00 4f 50 54 49 4f 4e | 31 07 00 45 4e 41 42 4c |..OPTION|1..ENABL|
|000026c0| 45 44 07 00 4f 50 54 49 | 4f 4e 32 05 00 56 41 4c |ED..OPTI|ON2..VAL|
|000026d0| 55 45 1c 00 07 00 af f7 | 00 00 fe 12 00 52 2c ce |UE......|.....R,.|
|000026e0| fc f8 01 02 fd fc f5 0d | f7 00 00 fd fe 03 00 55 |........|.......U|
|000026f0| 01 00 08 00 43 4d 45 53 | 53 41 47 45 bf 00 10 00 |....CMES|SAGE....|
|00002700| 25 fc f4 00 00 f7 01 00 | fd f9 05 b8 00 fe 0b 00 |%.......|........|
|00002710| ae f7 02 00 07 f7 03 00 | fe 0d 00 15 f6 02 00 fc |........|........|
|00002720| f8 01 01 fd 16 fe 2c 00 | 25 fc 43 f4 00 00 f7 04 |......,.|%.C.....|
|00002730| 00 a1 0a f0 16 00 43 d9 | 08 00 44 41 54 41 42 41 |......C.|..DATABA|
|00002740| 53 45 76 f4 00 00 f7 04 | 00 0f 03 09 fd f9 05 63 |SEv.....|.......c|
|00002750| 00 fe 0f 00 47 7f 28 fc | f4 00 00 f7 04 00 03 fd |....G.(.|........|
|00002760| fe 04 00 1e fe 19 00 54 | f7 03 00 10 fc 43 ea 19 |.......T|.....C..|
|00002770| f7 02 00 d9 04 00 56 49 | 45 57 ea 98 fd fe 11 00 |......VI|EW......|
|00002780| 25 fc f7 03 00 f8 01 00 | 11 fd f9 05 b4 00 fe 10 |%.......|........|
|00002790| 00 15 f4 00 00 f6 05 00 | fc f8 01 01 fd 16 fe 13 |........|........|
|000027a0| 00 99 fc 43 eb f7 02 00 | f4 00 00 e0 05 00 ea 0d |...C....|........|
|000027b0| fd fe 04 00 1e fe 04 00 | 1e fe 03 00 55 06 00 04 |........|....U...|
|000027c0| 00 54 48 49 53 09 00 4c | 41 4c 4c 56 49 45 57 53 |.THIS..L|ALLVIEWS|
|000027d0| 09 00 41 54 4d 50 56 49 | 45 57 53 09 00 4e 54 4f |..ATMPVI|EWS..NTO|
|000027e0| 54 56 49 45 57 53 09 00 | 43 44 41 54 41 42 41 53 |TVIEWS..|CDATABAS|
|000027f0| 45 06 00 43 56 49 45 57 | 53 57 00 1c 00 25 fc f4 |E..CVIEW|SW...%..|
|00002800| 00 00 f7 01 00 f0 09 00 | 43 f4 00 00 f7 02 00 a1 |........|C.......|
|00002810| 09 fd f9 05 36 00 fe 1a | 00 54 f4 00 00 f7 02 00 |....6...|.T......|
|00002820| 10 fc 43 d9 08 00 44 41 | 54 41 42 41 53 45 76 fd |..C...DA|TABASEv.|
|00002830| fe 04 00 1e fe 0d 00 99 | fc 43 f4 00 00 f6 03 00 |........|.C......|
|00002840| fd fe 0d 00 99 fc 43 f4 | 00 00 f6 04 00 fd fe 03 |......C.|........|
|00002850| 00 55 05 00 04 00 54 48 | 49 53 0e 00 4c 55 53 45 |.U....TH|IS..LUSE|
|00002860| 43 55 52 52 45 4e 54 44 | 42 43 09 00 43 44 41 54 |CURRENTD|BC..CDAT|
|00002870| 41 42 41 53 45 08 00 53 | 45 54 56 49 45 57 53 0c |ABASE..S|ETVIEWS.|
|00002880| 00 43 48 45 43 4b 4f 46 | 46 4c 49 4e 45 09 00 67 |.CHECKOF|FLINE..g|
|00002890| 6f 6f 66 66 6c 69 6e 65 | 2c 00 00 00 00 00 ff ff |ooffline|,.......|
|000028a0| 08 00 67 6f 6f 6e 6c 69 | 6e 65 67 02 00 00 00 00 |..goonli|neg.....|
|000028b0| ff ff 0c 00 63 68 65 63 | 6b 6f 66 66 6c 69 6e 65 |....chec|koffline|
|000028c0| d0 06 00 00 00 00 ff ff | 05 00 61 6c 65 72 74 72 |........|..alertr|
|000028d0| 08 00 00 00 00 ff ff 08 | 00 73 65 74 76 69 65 77 |........|.setview|
|000028e0| 73 9c 08 00 00 00 00 ff | ff 04 00 49 6e 69 74 99 |s.......|...Init.|
|000028f0| 09 00 00 00 00 ff ff 31 | 00 b1 00 c2 02 f1 00 41 |.......1|.......A|
|00002900| 00 62 01 31 03 71 00 41 | 00 c2 01 b2 02 41 00 41 |.b.1.q.A|.....A.A|
|00002910| 00 b1 01 51 04 01 01 b1 | 01 61 01 41 00 31 01 71 |...Q....|.a.A.1.q|
|00002920| 00 41 00 41 00 41 00 52 | 03 33 00 51 02 b2 00 02 |.A.A.A.R|.3.Q....|
|00002930| 01 61 01 c2 02 f1 00 41 | 00 62 01 31 03 41 00 41 |.a.....A|.b.1.A.A|
|00002940| 00 c2 00 c1 01 c2 02 41 | 00 41 00 01 01 91 01 f1 |.......A|.A......|
|00002950| 00 41 01 81 00 81 00 41 | 00 61 01 e1 00 92 03 b1 |.A.....A|.a......|
|00002960| 00 41 00 41 00 31 01 51 | 01 01 01 31 01 11 05 b1 |.A.A.1.Q|...1....|
|00002970| 00 41 00 41 00 41 00 a1 | 01 f1 00 41 01 41 00 01 |.A.A.A..|...A.A..|
|00002980| 01 61 03 b1 00 41 00 41 | 00 41 00 f2 00 31 01 81 |.a...A.A|.A...1..|
|00002990| 00 41 03 41 00 c1 00 33 | 00 b1 00 c2 02 f1 00 41 |.A.A...3|.......A|
|000029a0| 00 22 02 42 01 41 01 41 | 00 41 00 42 01 41 01 c2 |.".B.A.A|.A.B.A..|
|000029b0| 01 b1 02 e1 00 41 00 41 | 00 41 00 32 02 33 00 71 |.....A.A|.A.2.3.q|
|000029c0| 00 21 01 32 00 02 01 b1 | 00 d1 00 c1 02 f1 00 41 |.!.2....|.......A|
|000029d0| 00 91 01 11 01 01 01 31 | 01 41 00 41 00 33 00 c1 |.......1|.A.A.3..|
|000029e0| 01 a1 01 41 00 d1 00 d1 | 00 32 00 00 00 00 00 00 |...A....|.2......|
|000029f0| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 15 |........|........|
|00002a00| 00 00 00 73 02 00 00 01 | 00 00 00 1a 00 00 00 92 |...s....|........|
|00002a10| 02 00 00 f4 07 00 00 21 | 00 00 00 51 00 00 00 17 |.......!|...Q....|
|00002a20| 08 00 00 4a 0a 00 00 62 | 00 00 00 64 00 00 00 66 |...J...b|...d...f|
|00002a30| 0a 00 00 9b 0a 00 00 7d | 00 00 00 67 00 00 00 ba |.......}|...g....|
|00002a40| 0a 00 00 40 0c 00 00 81 | 00 00 00 74 00 00 00 5b |...@....|...t...[|
|00002a50| 0c 00 00 dd 0c 00 00 91 | 00 00 00 00 29 00 00 00 |........|....)...|
|00002a60| 24 0c 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |$.......|........|
|00002a70| 00 00 00 00 00 00 00 01 | 00 00 0c e8 50 52 4f 43 |........|....PROC|
|00002a80| 45 44 55 52 45 20 67 6f | 6f 66 66 6c 69 6e 65 0d |EDURE go|offline.|
|00002a90| 0a 4c 4f 43 41 4c 20 69 | 2c 6a 0d 0a 0d 0a 49 46 |.LOCAL i|,j....IF|
|00002aa0| 20 21 45 4d 50 54 59 28 | 54 48 49 53 2e 63 44 61 | !EMPTY(|THIS.cDa|
|00002ab0| 74 61 62 61 73 65 29 20 | 41 4e 44 20 28 53 45 54 |tabase) |AND (SET|
|00002ac0| 28 22 44 41 54 41 42 41 | 53 45 22 29 20 23 20 54 |("DATABA|SE") # T|
|00002ad0| 48 49 53 2e 63 44 61 74 | 61 62 61 73 65 29 0d 0a |HIS.cDat|abase)..|
|00002ae0| 09 53 45 54 20 44 41 54 | 41 42 41 53 45 20 54 4f |.SET DAT|ABASE TO|
|00002af0| 20 28 54 48 49 53 2e 63 | 44 61 74 61 62 61 73 65 | (THIS.c|Database|
|00002b00| 29 0d 0a 45 4e 44 49 46 | 0d 0a 0d 0a 49 46 20 45 |)..ENDIF|....IF E|
|00002b10| 4d 50 54 59 28 54 48 49 | 53 2e 63 56 69 65 77 73 |MPTY(THI|S.cViews|
|00002b20| 5b 31 5d 29 0d 0a 09 54 | 48 49 53 2e 41 6c 65 72 |[1])...T|HIS.Aler|
|00002b30| 74 28 43 5f 4e 4f 56 49 | 45 57 53 5f 4c 4f 43 29 |t(C_NOVI|EWS_LOC)|
|00002b40| 0d 0a 09 52 45 54 55 52 | 4e 20 2e 46 2e 0d 0a 45 |...RETUR|N .F...E|
|00002b50| 4e 44 49 46 0d 0a 0d 0a | 46 4f 52 20 69 20 3d 20 |NDIF....|FOR i = |
|00002b60| 31 20 54 4f 20 41 4c 45 | 4e 28 54 48 49 53 2e 63 |1 TO ALE|N(THIS.c|
|00002b70| 56 69 65 77 73 29 0d 0a | 09 2a 20 43 68 65 63 6b |Views)..|.* Check|
|00002b80| 20 69 66 20 61 6c 72 65 | 61 64 79 20 6f 66 66 6c | if alre|ady offl|
|00002b90| 69 6e 65 0d 0a 09 49 46 | 20 44 42 47 45 54 50 52 |ine...IF| DBGETPR|
|00002ba0| 4f 50 28 54 48 49 53 2e | 63 56 69 65 77 73 5b 6d |OP(THIS.|cViews[m|
|00002bb0| 2e 69 5d 2c 22 56 49 45 | 57 22 2c 22 4f 46 46 4c |.i],"VIE|W","OFFL|
|00002bc0| 49 4e 45 22 29 0d 0a 09 | 09 4c 4f 4f 50 0d 0a 09 |INE")...|.LOOP...|
|00002bd0| 45 4e 44 49 46 0d 0a 09 | 49 46 20 21 43 52 45 41 |ENDIF...|IF !CREA|
|00002be0| 54 45 4f 46 46 4c 49 4e | 45 28 54 48 49 53 2e 63 |TEOFFLIN|E(THIS.c|
|00002bf0| 56 69 65 77 73 5b 6d 2e | 69 5d 29 0d 0a 09 09 54 |Views[m.|i])....T|
|00002c00| 48 49 53 2e 41 6c 65 72 | 74 28 43 5f 46 41 49 4c |HIS.Aler|t(C_FAIL|
|00002c10| 4f 46 46 4c 49 4e 45 5f | 4c 4f 43 2b 54 48 49 53 |OFFLINE_|LOC+THIS|
|00002c20| 2e 63 56 69 65 77 73 5b | 6d 2e 69 5d 29 0d 0a 09 |.cViews[|m.i])...|
|00002c30| 09 49 46 20 54 48 49 53 | 2e 6c 52 65 76 65 72 74 |.IF THIS|.lRevert|
|00002c40| 4f 6e 46 61 69 6c 0d 0a | 09 09 09 46 4f 52 20 6a |OnFail..|...FOR j|
|00002c50| 20 3d 20 31 20 54 4f 20 | 69 2d 31 0d 0a 09 09 09 | = 1 TO |i-1.....|
|00002c60| 09 44 52 4f 50 4f 46 46 | 4c 49 4e 45 28 54 48 49 |.DROPOFF|LINE(THI|
|00002c70| 53 2e 63 56 69 65 77 73 | 5b 6d 2e 69 5d 29 0d 0a |S.cViews|[m.i])..|
|00002c80| 09 09 09 45 4e 44 46 4f | 52 0d 0a 09 09 09 54 48 |...ENDFO|R.....TH|
|00002c90| 49 53 2e 6f 67 4f 66 66 | 6c 69 6e 65 2e 76 61 6c |IS.ogOff|line.val|
|00002ca0| 75 65 20 3d 20 31 0d 0a | 09 09 09 52 45 54 55 52 |ue = 1..|...RETUR|
|00002cb0| 4e 20 2e 46 2e 0d 0a 09 | 09 45 4e 44 49 46 0d 0a |N .F....|.ENDIF..|
|00002cc0| 09 45 4e 44 49 46 0d 0a | 45 4e 44 46 4f 52 0d 0a |.ENDIF..|ENDFOR..|
|00002cd0| 0d 0a 54 48 49 53 2e 41 | 6c 65 72 74 28 43 5f 4f |..THIS.A|lert(C_O|
|00002ce0| 4b 4f 46 46 4c 49 4e 45 | 5f 4c 4f 43 29 0d 0a 0d |KOFFLINE|_LOC)...|
|00002cf0| 0a 45 4e 44 50 52 4f 43 | 0d 0a 50 52 4f 43 45 44 |.ENDPROC|..PROCED|
|00002d00| 55 52 45 20 67 6f 6f 6e | 6c 69 6e 65 0d 0a 4c 4f |URE goon|line..LO|
|00002d10| 43 41 4c 20 6c 55 70 64 | 61 74 65 53 75 63 63 65 |CAL lUpd|ateSucce|
|00002d20| 73 73 2c 6c 44 72 6f 70 | 53 75 63 63 65 73 73 2c |ss,lDrop|Success,|
|00002d30| 61 55 70 64 61 74 65 45 | 72 72 6f 72 73 5b 31 5d |aUpdateE|rrors[1]|
|00002d40| 2c 69 2c 6c 41 62 6f 72 | 74 2c 6c 41 6c 72 65 61 |,i,lAbor|t,lAlrea|
|00002d50| 64 79 55 73 65 64 2c 6e | 53 61 76 65 41 72 65 61 |dyUsed,n|SaveArea|
|00002d60| 0d 0a 0d 0a 6c 41 62 6f | 72 74 20 3d 20 2e 46 2e |....lAbo|rt = .F.|
|00002d70| 0d 0a 0d 0a 44 49 4d 45 | 4e 53 49 4f 4e 20 54 48 |....DIME|NSION TH|
|00002d80| 49 53 2e 61 55 70 64 61 | 74 65 45 72 72 6f 72 73 |IS.aUpda|teErrors|
|00002d90| 5b 31 5d 0d 0a 54 48 49 | 53 2e 61 55 70 64 61 74 |[1]..THI|S.aUpdat|
|00002da0| 65 45 72 72 6f 72 73 5b | 31 5d 20 3d 20 30 0d 0a |eErrors[|1] = 0..|
|00002db0| 0d 0a 49 46 20 21 45 4d | 50 54 59 28 54 48 49 53 |..IF !EM|PTY(THIS|
|00002dc0| 2e 63 44 61 74 61 62 61 | 73 65 29 20 41 4e 44 20 |.cDataba|se) AND |
|00002dd0| 28 53 45 54 28 22 44 41 | 54 41 42 41 53 45 22 29 |(SET("DA|TABASE")|
|00002de0| 20 23 20 54 48 49 53 2e | 63 44 61 74 61 62 61 73 | # THIS.|cDatabas|
|00002df0| 65 29 0d 0a 09 53 45 54 | 20 44 41 54 41 42 41 53 |e)...SET| DATABAS|
|00002e00| 45 20 54 4f 20 28 54 48 | 49 53 2e 63 44 61 74 61 |E TO (TH|IS.cData|
|00002e10| 62 61 73 65 29 0d 0a 45 | 4e 44 49 46 0d 0a 0d 0a |base)..E|NDIF....|
|00002e20| 49 46 20 45 4d 50 54 59 | 28 54 48 49 53 2e 63 56 |IF EMPTY|(THIS.cV|
|00002e30| 69 65 77 73 5b 31 5d 29 | 0d 0a 09 54 48 49 53 2e |iews[1])|...THIS.|
|00002e40| 41 6c 65 72 74 28 43 5f | 4e 4f 56 49 45 57 53 5f |Alert(C_|NOVIEWS_|
|00002e50| 4c 4f 43 29 0d 0a 09 52 | 45 54 55 52 4e 0d 0a 45 |LOC)...R|ETURN..E|
|00002e60| 4e 44 49 46 0d 0a 0d 0a | 6e 53 61 76 65 41 72 65 |NDIF....|nSaveAre|
|00002e70| 61 20 3d 20 53 45 4c 45 | 43 54 28 29 0d 0a 46 4f |a = SELE|CT()..FO|
|00002e80| 52 20 69 20 3d 20 31 20 | 54 4f 20 41 4c 45 4e 28 |R i = 1 |TO ALEN(|
|00002e90| 54 48 49 53 2e 63 56 69 | 65 77 73 29 0d 0a 09 2a |THIS.cVi|ews)...*|
|00002ea0| 20 43 68 65 63 6b 20 69 | 66 20 61 6c 72 65 61 64 | Check i|f alread|
|00002eb0| 79 20 6f 6e 6c 69 6e 65 | 0d 0a 09 49 46 20 21 44 |y online|...IF !D|
|00002ec0| 42 47 45 54 50 52 4f 50 | 28 54 48 49 53 2e 63 56 |BGETPROP|(THIS.cV|
|00002ed0| 69 65 77 73 5b 6d 2e 69 | 5d 2c 22 56 49 45 57 22 |iews[m.i|],"VIEW"|
|00002ee0| 2c 22 4f 46 46 4c 49 4e | 45 22 29 0d 0a 09 09 4c |,"OFFLIN|E")....L|
|00002ef0| 4f 4f 50 0d 0a 09 45 4e | 44 49 46 0d 0a 09 49 46 |OOP...EN|DIF...IF|
|00002f00| 20 54 48 49 53 2e 6c 55 | 70 64 61 74 65 56 69 65 | THIS.lU|pdateVie|
|00002f10| 77 73 0d 0a 09 09 6c 41 | 6c 72 65 61 64 79 55 73 |ws....lA|lreadyUs|
|00002f20| 65 64 20 3d 20 55 53 45 | 44 28 54 48 49 53 2e 63 |ed = USE|D(THIS.c|
|00002f30| 56 69 65 77 73 5b 6d 2e | 69 5d 29 0d 0a 09 09 49 |Views[m.|i])....I|
|00002f40| 46 20 6d 2e 6c 41 6c 72 | 65 61 64 79 55 73 65 64 |F m.lAlr|eadyUsed|
|00002f50| 20 0d 0a 09 09 09 53 45 | 4c 45 43 54 20 28 54 48 | .....SE|LECT (TH|
|00002f60| 49 53 2e 63 56 69 65 77 | 73 5b 6d 2e 69 5d 29 0d |IS.cView|s[m.i]).|
|00002f70| 0a 09 09 45 4c 53 45 0d | 0a 09 09 09 53 45 4c 45 |...ELSE.|....SELE|
|00002f80| 43 54 20 30 0d 0a 09 09 | 45 4e 44 49 46 0d 0a 09 |CT 0....|ENDIF...|
|00002f90| 09 55 53 45 20 28 54 48 | 49 53 2e 63 56 69 65 77 |.USE (TH|IS.cView|
|00002fa0| 73 5b 6d 2e 69 5d 29 20 | 4f 4e 4c 49 4e 45 20 45 |s[m.i]) |ONLINE E|
|00002fb0| 58 43 4c 55 53 49 56 45 | 0d 0a 09 09 49 46 20 45 |XCLUSIVE|....IF E|
|00002fc0| 4d 50 54 59 28 41 4c 49 | 41 53 28 29 29 0d 0a 09 |MPTY(ALI|AS())...|
|00002fd0| 09 09 2a 20 46 61 69 6c | 65 64 20 74 6f 20 6f 70 |..* Fail|ed to op|
|00002fe0| 65 6e 20 65 78 63 6c 75 | 73 69 76 65 6c 79 0d 0a |en exclu|sively..|
|00002ff0| 09 09 09 4d 45 53 53 41 | 47 45 42 4f 58 28 43 5f |...MESSA|GEBOX(C_|
|00003000| 4e 4f 4f 50 45 4e 5f 4c | 4f 43 2b 54 48 49 53 2e |NOOPEN_L|OC+THIS.|
|00003010| 63 56 69 65 77 73 5b 6d | 2e 69 5d 29 0d 0a 09 09 |cViews[m|.i])....|
|00003020| 09 6c 41 62 6f 72 74 20 | 3d 20 2e 54 2e 0d 0a 09 |.lAbort |= .T....|
|00003030| 09 09 45 58 49 54 0d 0a | 09 09 45 4e 44 49 46 0d |..EXIT..|..ENDIF.|
|00003040| 0a 09 09 6c 55 70 64 61 | 74 65 53 75 63 63 65 73 |...lUpda|teSucces|
|00003050| 73 20 3d 20 54 61 62 6c | 65 55 70 64 61 74 65 28 |s = Tabl|eUpdate(|
|00003060| 32 2c 61 55 70 64 61 74 | 65 45 72 72 6f 72 73 29 |2,aUpdat|eErrors)|
|00003070| 0d 0a 09 09 55 53 45 20 | 49 4e 20 28 54 48 49 53 |....USE |IN (THIS|
|00003080| 2e 63 56 69 65 77 73 5b | 6d 2e 69 5d 29 0d 0a 09 |.cViews[|m.i])...|
|00003090| 09 49 46 20 21 6d 2e 6c | 55 70 64 61 74 65 53 75 |.IF !m.l|UpdateSu|
|000030a0| 63 63 65 73 73 0d 0a 09 | 09 09 41 43 4f 50 59 28 |ccess...|..ACOPY(|
|000030b0| 61 55 70 64 61 74 65 45 | 72 72 6f 72 73 2c 54 48 |aUpdateE|rrors,TH|
|000030c0| 49 53 2e 61 55 70 64 61 | 74 65 45 72 72 6f 72 73 |IS.aUpda|teErrors|
|000030d0| 29 0d 0a 09 09 09 4d 45 | 53 53 41 47 45 42 4f 58 |).....ME|SSAGEBOX|
|000030e0| 28 43 5f 52 45 43 4f 52 | 44 43 4f 4e 4c 49 43 54 |(C_RECOR|DCONLICT|
|000030f0| 5f 4c 4f 43 2b 54 48 49 | 53 2e 63 56 69 65 77 73 |_LOC+THI|S.cViews|
|00003100| 5b 6d 2e 69 5d 29 0d 0a | 09 09 09 6c 41 62 6f 72 |[m.i])..|...lAbor|
|00003110| 74 20 3d 20 2e 54 2e 0d | 0a 09 09 09 45 58 49 54 |t = .T..|....EXIT|
|00003120| 0d 0a 09 09 45 4e 44 49 | 46 0d 0a 09 45 4e 44 49 |....ENDI|F...ENDI|
|00003130| 46 0d 0a 09 6c 44 72 6f | 70 53 75 63 63 65 73 73 |F...lDro|pSuccess|
|00003140| 20 3d 20 44 52 4f 50 4f | 46 46 4c 49 4e 45 28 54 | = DROPO|FFLINE(T|
|00003150| 48 49 53 2e 63 56 69 65 | 77 73 5b 6d 2e 69 5d 29 |HIS.cVie|ws[m.i])|
|00003160| 0d 0a 09 49 46 20 6d 2e | 6c 41 6c 72 65 61 64 79 |...IF m.|lAlready|
|00003170| 55 73 65 64 0d 0a 09 09 | 55 53 45 20 28 54 48 49 |Used....|USE (THI|
|00003180| 53 2e 63 56 69 65 77 73 | 5b 6d 2e 69 5d 29 0d 0a |S.cViews|[m.i])..|
|00003190| 09 45 4e 44 49 46 0d 0a | 09 49 46 20 21 6d 2e 6c |.ENDIF..|.IF !m.l|
|000031a0| 44 72 6f 70 53 75 63 63 | 65 73 73 0d 0a 09 09 4d |DropSucc|ess....M|
|000031b0| 45 53 53 41 47 45 42 4f | 58 28 43 5f 46 41 49 4c |ESSAGEBO|X(C_FAIL|
|000031c0| 4f 4e 4c 49 4e 45 5f 4c | 4f 43 2b 54 48 49 53 2e |ONLINE_L|OC+THIS.|
|000031d0| 63 56 69 65 77 73 5b 6d | 2e 69 5d 29 0d 0a 09 09 |cViews[m|.i])....|
|000031e0| 6c 41 62 6f 72 74 20 3d | 20 2e 54 2e 0d 0a 09 09 |lAbort =| .T.....|
|000031f0| 45 58 49 54 0d 0a 09 45 | 4e 44 49 46 0d 0a 45 4e |EXIT...E|NDIF..EN|
|00003200| 44 46 4f 52 0d 0a 0d 0a | 49 46 20 6d 2e 6c 41 62 |DFOR....|IF m.lAb|
|00003210| 6f 72 74 0d 0a 09 54 48 | 49 53 2e 6f 67 4f 66 66 |ort...TH|IS.ogOff|
|00003220| 6c 69 6e 65 2e 76 61 6c | 75 65 20 3d 20 32 0d 0a |line.val|ue = 2..|
|00003230| 45 4c 53 45 0d 0a 09 54 | 48 49 53 2e 41 6c 65 72 |ELSE...T|HIS.Aler|
|00003240| 74 28 43 5f 4f 4b 4f 4e | 4c 49 4e 45 5f 4c 4f 43 |t(C_OKON|LINE_LOC|
|00003250| 29 0d 0a 45 4e 44 49 46 | 0d 0a 53 45 4c 45 43 54 |)..ENDIF|..SELECT|
|00003260| 20 28 6d 2e 6e 53 61 76 | 65 41 72 65 61 29 0d 0a | (m.nSav|eArea)..|
|00003270| 0d 0a 45 4e 44 50 52 4f | 43 0d 0a 50 52 4f 43 45 |..ENDPRO|C..PROCE|
|00003280| 44 55 52 45 20 63 68 65 | 63 6b 6f 66 66 6c 69 6e |DURE che|ckofflin|
|00003290| 65 0d 0a 4c 4f 43 41 4c | 20 6c 4f 66 66 6c 69 6e |e..LOCAL| lOfflin|
|000032a0| 65 2c 69 0d 0a 0d 0a 49 | 46 20 21 45 4d 50 54 59 |e,i....I|F !EMPTY|
|000032b0| 28 54 48 49 53 2e 63 44 | 61 74 61 62 61 73 65 29 |(THIS.cD|atabase)|
|000032c0| 20 41 4e 44 20 28 53 45 | 54 28 22 44 41 54 41 42 | AND (SE|T("DATAB|
|000032d0| 41 53 45 22 29 20 23 20 | 54 48 49 53 2e 63 44 61 |ASE") # |THIS.cDa|
|000032e0| 74 61 62 61 73 65 29 0d | 0a 09 53 45 54 20 44 41 |tabase).|..SET DA|
|000032f0| 54 41 42 41 53 45 20 54 | 4f 20 28 54 48 49 53 2e |TABASE T|O (THIS.|
|00003300| 63 44 61 74 61 62 61 73 | 65 29 0d 0a 45 4e 44 49 |cDatabas|e)..ENDI|
|00003310| 46 0d 0a 0d 0a 49 46 20 | 45 4d 50 54 59 28 54 48 |F....IF |EMPTY(TH|
|00003320| 49 53 2e 63 44 61 74 61 | 62 61 73 65 29 20 4f 52 |IS.cData|base) OR|
|00003330| 20 45 4d 50 54 59 28 54 | 48 49 53 2e 63 56 69 65 | EMPTY(T|HIS.cVie|
|00003340| 77 73 5b 31 5d 29 0d 0a | 09 2a 54 48 49 53 2e 41 |ws[1])..|.*THIS.A|
|00003350| 6c 65 72 74 28 43 5f 4e | 4f 44 41 54 41 42 41 53 |lert(C_N|ODATABAS|
|00003360| 45 5f 4c 4f 43 29 0d 0a | 09 54 48 49 53 2e 6f 67 |E_LOC)..|.THIS.og|
|00003370| 4f 66 66 6c 69 6e 65 2e | 4f 70 74 69 6f 6e 31 2e |Offline.|Option1.|
|00003380| 45 6e 61 62 6c 65 64 20 | 3d 20 2e 46 2e 0d 0a 09 |Enabled |= .F....|
|00003390| 54 48 49 53 2e 6f 67 4f | 66 66 6c 69 6e 65 2e 4f |THIS.ogO|ffline.O|
|000033a0| 70 74 69 6f 6e 32 2e 45 | 6e 61 62 6c 65 64 20 3d |ption2.E|nabled =|
|000033b0| 20 2e 46 2e 0d 0a 09 52 | 45 54 55 52 4e 20 0d 0a | .F....R|ETURN ..|
|000033c0| 45 4e 44 49 46 0d 0a 0d | 0a 54 48 49 53 2e 6f 67 |ENDIF...|.THIS.og|
|000033d0| 4f 66 66 6c 69 6e 65 2e | 4f 70 74 69 6f 6e 31 2e |Offline.|Option1.|
|000033e0| 45 6e 61 62 6c 65 64 20 | 3d 20 2e 54 2e 0d 0a 54 |Enabled |= .T...T|
|000033f0| 48 49 53 2e 6f 67 4f 66 | 66 6c 69 6e 65 2e 4f 70 |HIS.ogOf|fline.Op|
|00003400| 74 69 6f 6e 32 2e 45 6e | 61 62 6c 65 64 20 3d 20 |tion2.En|abled = |
|00003410| 2e 54 2e 0d 0a 0d 0a 46 | 4f 52 20 69 20 3d 20 31 |.T.....F|OR i = 1|
|00003420| 20 54 4f 20 41 4c 45 4e | 28 54 48 49 53 2e 63 56 | TO ALEN|(THIS.cV|
|00003430| 69 65 77 73 29 0d 0a 09 | 6c 4f 66 66 6c 69 6e 65 |iews)...|lOffline|
|00003440| 20 3d 20 44 42 47 45 54 | 50 52 4f 50 28 54 48 49 | = DBGET|PROP(THI|
|00003450| 53 2e 63 56 69 65 77 73 | 5b 6d 2e 69 5d 2c 22 56 |S.cViews|[m.i],"V|
|00003460| 49 45 57 22 2c 22 4f 46 | 46 4c 49 4e 45 22 29 0d |IEW","OF|FLINE").|
|00003470| 0a 09 49 46 20 21 6c 4f | 66 66 6c 69 6e 65 0d 0a |..IF !lO|ffline..|
|00003480| 09 09 45 58 49 54 0d 0a | 09 45 4e 44 49 46 0d 0a |..EXIT..|.ENDIF..|
|00003490| 45 4e 44 46 4f 52 0d 0a | 0d 0a 54 48 49 53 2e 6f |ENDFOR..|..THIS.o|
|000034a0| 67 4f 66 66 6c 69 6e 65 | 2e 76 61 6c 75 65 20 3d |gOffline|.value =|
|000034b0| 20 49 49 46 28 6d 2e 6c | 4f 66 66 6c 69 6e 65 2c | IIF(m.l|Offline,|
|000034c0| 32 2c 31 29 0d 0a 0d 0a | 45 4e 44 50 52 4f 43 0d |2,1)....|ENDPROC.|
|000034d0| 0a 50 52 4f 43 45 44 55 | 52 45 20 61 6c 65 72 74 |.PROCEDU|RE alert|
|000034e0| 0d 0a 4c 50 41 52 41 4d | 45 54 45 52 20 63 4d 65 |..LPARAM|ETER cMe|
|000034f0| 73 73 61 67 65 0d 0a 57 | 41 49 54 20 57 49 4e 44 |ssage..W|AIT WIND|
|00003500| 4f 57 20 6d 2e 63 4d 65 | 73 73 61 67 65 20 54 49 |OW m.cMe|ssage TI|
|00003510| 4d 45 4f 55 54 20 32 0d | 0a 45 4e 44 50 52 4f 43 |MEOUT 2.|.ENDPROC|
|00003520| 0d 0a 50 52 4f 43 45 44 | 55 52 45 20 73 65 74 76 |..PROCED|URE setv|
|00003530| 69 65 77 73 0d 0a 2a 20 | 41 62 73 74 72 61 63 74 |iews..* |Abstract|
|00003540| 20 63 6c 61 73 73 20 74 | 6f 20 73 65 74 75 70 20 | class t|o setup |
|00003550| 54 48 49 53 2e 63 56 69 | 65 77 73 20 61 72 72 61 |THIS.cVi|ews arra|
|00003560| 79 20 61 6e 64 20 54 48 | 49 53 2e 63 44 61 74 61 |y and TH|IS.cData|
|00003570| 62 61 73 65 20 28 6f 70 | 74 69 6f 6e 61 6c 29 0d |base (op|tional).|
|00003580| 0a 49 46 20 54 48 49 53 | 2e 6c 41 6c 6c 56 69 65 |.IF THIS|.lAllVie|
|00003590| 77 73 0d 0a 09 4c 4f 43 | 41 4c 20 61 54 6d 70 56 |ws...LOC|AL aTmpV|
|000035a0| 69 65 77 73 2c 6e 54 6f | 74 56 69 65 77 73 0d 0a |iews,nTo|tViews..|
|000035b0| 09 44 49 4d 45 4e 53 49 | 4f 4e 20 61 54 6d 70 56 |.DIMENSI|ON aTmpV|
|000035c0| 69 65 77 73 5b 31 5d 0d | 0a 09 49 46 20 21 45 4d |iews[1].|..IF !EM|
|000035d0| 50 54 59 28 54 48 49 53 | 2e 63 44 61 74 61 62 61 |PTY(THIS|.cDataba|
|000035e0| 73 65 29 20 41 4e 44 20 | 28 53 45 54 28 22 44 41 |se) AND |(SET("DA|
|000035f0| 54 41 42 41 53 45 22 29 | 23 54 48 49 53 2e 63 44 |TABASE")|#THIS.cD|
|00003600| 61 74 61 62 61 73 65 29 | 0d 0a 09 09 53 45 54 20 |atabase)|....SET |
|00003610| 44 41 54 41 42 41 53 45 | 20 54 4f 20 28 54 48 49 |DATABASE| TO (THI|
|00003620| 53 2e 63 44 61 74 61 62 | 61 73 65 29 0d 0a 09 45 |S.cDatab|ase)...E|
|00003630| 4e 44 49 46 0d 0a 09 6e | 54 6f 74 56 69 65 77 73 |NDIF...n|TotViews|
|00003640| 20 3d 20 41 44 42 4f 42 | 4a 45 43 54 28 61 54 6d | = ADBOB|JECT(aTm|
|00003650| 70 56 69 65 77 73 2c 22 | 56 49 45 57 22 29 0d 0a |pViews,"|VIEW")..|
|00003660| 09 49 46 20 6e 54 6f 74 | 56 69 65 77 73 3e 30 0d |.IF nTot|Views>0.|
|00003670| 0a 09 09 44 49 4d 45 4e | 53 49 4f 4e 20 54 48 49 |...DIMEN|SION THI|
|00003680| 53 2e 63 56 69 65 77 73 | 5b 31 5d 0d 0a 09 09 41 |S.cViews|[1]....A|
|00003690| 43 4f 50 59 28 61 54 6d | 70 56 69 65 77 73 2c 54 |COPY(aTm|pViews,T|
|000036a0| 48 49 53 2e 63 56 69 65 | 77 73 29 0d 0a 09 45 4e |HIS.cVie|ws)...EN|
|000036b0| 44 49 46 0d 0a 45 4e 44 | 49 46 0d 0a 0d 0a 45 4e |DIF..END|IF....EN|
|000036c0| 44 50 52 4f 43 0d 0a 50 | 52 4f 43 45 44 55 52 45 |DPROC..P|ROCEDURE|
|000036d0| 20 49 6e 69 74 0d 0a 49 | 46 20 54 48 49 53 2e 6c | Init..I|F THIS.l|
|000036e0| 55 73 65 43 75 72 72 65 | 6e 74 44 42 43 20 41 4e |UseCurre|ntDBC AN|
|000036f0| 44 20 45 4d 50 54 59 28 | 54 48 49 53 2e 63 44 61 |D EMPTY(|THIS.cDa|
|00003700| 74 61 62 61 73 65 29 0d | 0a 09 54 48 49 53 2e 63 |tabase).|..THIS.c|
|00003710| 44 61 74 61 62 61 73 65 | 20 3d 20 53 45 54 28 22 |Database| = SET("|
|00003720| 44 41 54 41 42 41 53 45 | 22 29 0d 0a 45 4e 44 49 |DATABASE|")..ENDI|
|00003730| 46 0d 0a 54 48 49 53 2e | 53 65 74 56 69 65 77 73 |F..THIS.|SetViews|
|00003740| 28 29 0d 0a 54 48 49 53 | 2e 43 68 65 63 6b 4f 66 |()..THIS|.CheckOf|
|00003750| 66 6c 69 6e 65 28 29 0d | 0a 0d 0a 45 4e 44 50 52 |fline().|...ENDPR|
|00003760| 4f 43 0d 0a 00 00 00 01 | 00 00 00 8c 57 69 64 74 |OC......|....Widt|
|00003770| 68 20 3d 20 31 31 39 0d | 0a 48 65 69 67 68 74 20 |h = 119.|.Height |
|00003780| 3d 20 36 34 0d 0a 42 61 | 63 6b 53 74 79 6c 65 20 |= 64..Ba|ckStyle |
|00003790| 3d 20 30 0d 0a 42 6f 72 | 64 65 72 57 69 64 74 68 |= 0..Bor|derWidth|
|000037a0| 20 3d 20 30 0d 0a 6c 72 | 65 76 65 72 74 6f 6e 66 | = 0..lr|evertonf|
|000037b0| 61 69 6c 20 3d 20 2e 54 | 2e 0d 0a 6c 75 70 64 61 |ail = .T|...lupda|
|000037c0| 74 65 76 69 65 77 73 20 | 3d 20 2e 54 2e 0d 0a 6c |teviews |= .T...l|
|000037d0| 75 73 65 63 75 72 72 65 | 6e 74 64 62 63 20 3d 20 |usecurre|ntdbc = |
|000037e0| 2e 54 2e 0d 0a 4e 61 6d | 65 20 3d 20 22 5f 6f 66 |.T...Nam|e = "_of|
|000037f0| 66 6c 69 6e 65 22 0d 0a | 00 00 00 01 00 00 00 09 |fline"..|........|
|00003800| 63 6f 6e 74 61 69 6e 65 | 72 00 00 00 01 00 00 00 |containe|r.......|
|00003810| 11 01 00 07 00 5f 64 61 | 74 61 2e 68 8a 95 fa 88 |....._da|ta.h....|
|00003820| 55 23 00 00 00 01 00 00 | 00 07 5f 65 78 65 63 73 |U#......|.._execs|
|00003830| 70 00 00 00 01 00 00 00 | 07 5f 64 61 74 61 2e 68 |p.......|._data.h|
|00003840| 00 00 00 01 00 00 00 56 | 63 63 75 72 73 6f 72 6e |.......V|ccursorn|
|00003850| 61 6d 65 0d 0a 68 63 6f | 6e 6e 65 63 74 68 61 6e |ame..hco|nnecthan|
|00003860| 64 6c 65 0d 0a 63 73 71 | 6c 0d 0a 63 73 70 6e 61 |dle..csq|l..cspna|
|00003870| 6d 65 0d 0a 61 70 61 72 | 61 6d 73 0d 0a 73 65 74 |me..apar|ams..set|
|00003880| 73 71 6c 0d 0a 73 65 74 | 70 61 72 61 6d 73 0d 0a |sql..set|params..|
|00003890| 70 72 6f 63 65 73 73 65 | 72 72 6f 72 0d 0a 00 00 |processe|rror....|
|000038a0| 00 01 00 00 00 06 50 69 | 78 65 6c 73 00 00 00 01 |......Pi|xels....|
|000038b0| 00 00 00 05 43 6c 61 73 | 73 00 00 00 01 00 00 00 |....Clas|s.......|
|000038c0| 07 5f 63 75 73 74 6f 6d | 00 00 00 01 00 00 00 07 |._custom|........|
|000038d0| 5f 65 78 65 63 73 70 00 | 00 00 01 00 00 00 d4 63 |_execsp.|.......c|
|000038e0| 63 75 72 73 6f 72 6e 61 | 6d 65 0d 0a 68 63 6f 6e |cursorna|me..hcon|
|000038f0| 6e 65 63 74 68 61 6e 64 | 6c 65 0d 0a 63 73 71 6c |necthand|le..csql|
|00003900| 0d 0a 63 73 70 6e 61 6d | 65 0d 0a 6c 75 73 65 73 |..cspnam|e..luses|
|00003910| 71 6c 73 79 6e 74 61 78 | 20 55 73 65 20 53 51 4c |qlsyntax| Use SQL|
|00003920| 20 53 65 72 76 65 72 20 | 45 78 65 63 20 73 79 6e | Server |Exec syn|
|00003930| 74 61 78 2e 0d 0a 2a 64 | 6f 73 71 6c 20 52 75 6e |tax...*d|osql Run|
|00003940| 73 20 53 50 54 20 73 74 | 61 74 65 6d 65 6e 74 2e |s SPT st|atement.|
|00003950| 0d 0a 5e 61 70 61 72 61 | 6d 73 5b 31 2c 30 5d 20 |..^apara|ms[1,0] |
|00003960| 0d 0a 2a 73 65 74 73 71 | 6c 20 0d 0a 2a 73 65 74 |..*setsq|l ..*set|
|00003970| 70 61 72 61 6d 73 20 0d | 0a 2a 70 72 6f 63 65 73 |params .|.*proces|
|00003980| 73 65 72 72 6f 72 20 0d | 0a 2a 67 65 74 73 71 6c |serror .|.*getsql|
|00003990| 20 47 65 74 73 20 72 65 | 73 75 6c 74 73 20 66 72 | Gets re|sults fr|
|000039a0| 6f 6d 20 53 50 54 20 73 | 74 61 74 65 6d 65 6e 74 |om SPT s|tatement|
|000039b0| 2e 0d 0a 00 00 00 01 00 | 00 00 2b 48 65 69 67 68 |........|..+Heigh|
|000039c0| 74 20 3d 20 31 39 0d 0a | 57 69 64 74 68 20 3d 20 |t = 19..|Width = |
|000039d0| 39 37 0d 0a 4e 61 6d 65 | 20 3d 20 22 5f 65 78 65 |97..Name| = "_exe|
|000039e0| 63 73 70 22 0d 0a 00 00 | 00 01 00 00 00 06 63 75 |csp"....|......cu|
|000039f0| 73 74 6f 6d 00 00 00 01 | 00 00 00 09 5f 62 61 73 |stom....|...._bas|
|00003a00| 65 2e 76 63 78 00 00 00 | 01 00 00 00 ca fe f2 ff |e.vcx...|........|
|00003a10| 20 02 01 00 00 00 b1 00 | 00 00 b1 00 00 00 00 00 | .......|........|
|00003a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a30| 00 00 00 00 d3 0c 01 00 | 00 00 25 00 00 00 53 00 |........|..%...S.|
|00003a40| 00 00 00 00 00 00 68 00 | 00 00 03 00 00 00 62 00 |......h.|......b.|
|00003a50| 00 00 00 00 00 00 00 00 | 00 00 fc 03 00 03 00 55 |........|.......U|
|00003a60| 00 00 10 00 0d 00 99 fc | 43 f4 00 00 f6 01 00 fd |........|C.......|
|00003a70| fe 03 00 55 02 00 08 00 | 54 48 49 53 46 4f 52 4d |...U....|THISFORM|
|00003a80| 07 00 52 45 4c 45 41 53 | 45 05 00 43 6c 69 63 6b |..RELEAS|E..Click|
|00003a90| 2c 00 00 00 00 00 ff ff | 31 00 d1 00 32 00 00 00 |,.......|1...2...|
|00003aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00003ab0| 00 00 11 00 00 00 25 00 | 00 00 01 00 00 00 00 29 |......%.|.......)|
|00003ac0| 00 00 00 b1 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ad0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 58 54 |........|......XT|
|00003ae0| 6f 70 20 3d 20 31 34 39 | 0d 0a 4c 65 66 74 20 3d |op = 149|..Left =|
|00003af0| 20 34 30 36 0d 0a 48 65 | 69 67 68 74 20 3d 20 32 | 406..He|ight = 2|
|00003b00| 33 0d 0a 57 69 64 74 68 | 20 3d 20 37 32 0d 0a 43 |3..Width| = 72..C|
|00003b10| 61 70 74 69 6f 6e 20 3d | 20 22 5c 3c 43 6c 6f 73 |aption =| "\<Clos|
|00003b20| 65 22 0d 0a 4e 61 6d 65 | 20 3d 20 22 63 6d 64 43 |e"..Name| = "cmdC|
|00003b30| 6c 6f 73 65 22 0d 0a 00 | 00 00 01 00 00 00 0a 5f |lose"...|......._|
|00003b40| 63 62 6f 6c 6f 6f 6b 75 | 70 00 00 00 01 00 00 00 |cbolooku|p.......|
|00003b50| 0a 5f 63 6f 6e 66 6c 69 | 63 74 73 00 00 00 01 00 |._confli|cts.....|
|00003b60| 00 00 29 4d 53 20 53 61 | 6e 73 20 53 65 72 69 66 |..)MS Sa|ns Serif|
|00003b70| 2c 20 30 2c 20 38 2c 20 | 35 2c 20 31 33 2c 20 31 |, 0, 8, |5, 13, 1|
|00003b80| 31 2c 20 31 31 2c 20 32 | 2c 20 30 0a 00 00 00 01 |1, 11, 2|, 0.....|
|00003b90| 00 00 00 11 01 00 07 00 | 5f 64 61 74 61 2e 68 8a |........|_data.h.|
|00003ba0| 95 fa 88 55 23 00 00 00 | 01 00 00 01 a8 fe f2 ff |...U#...|........|
|00003bb0| 20 02 01 00 00 00 8f 01 | 00 00 8f 01 00 00 00 00 | .......|........|
|00003bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bd0| 00 00 00 00 87 f2 01 00 | 00 00 25 00 00 00 21 01 |........|..%...!.|
|00003be0| 00 00 00 00 00 00 46 01 | 00 00 0b 00 00 00 30 01 |......F.|......0.|
|00003bf0| 00 00 00 00 00 00 00 00 | 00 00 fc 03 00 03 00 55 |........|.......U|
|00003c00| 00 00 b0 00 12 00 25 fc | 43 f4 00 00 f7 01 00 a1 |......%.|C.......|
|00003c10| fd f9 05 3d 00 fe 24 00 | 52 2c ce fc f8 01 02 fd |...=..$.|R,......|
|00003c20| fc d9 14 00 4e 6f 20 63 | 75 72 73 6f 72 20 73 70 |....No c|ursor sp|
|00003c30| 65 63 69 66 69 65 64 2e | fd fe 07 00 42 fc 2d fd |ecified.|....B.-.|
|00003c40| fe 04 00 1e fe 07 00 ae | f7 02 00 fe 0e 00 54 f7 |........|......T.|
|00003c50| 02 00 10 fc 43 2d ea 94 | fd fe 0d 00 99 fc 43 f4 |....C-..|......C.|
|00003c60| 00 00 f6 03 00 fd fe 3d | 00 99 fc 43 43 f7 02 00 |.......=|...CC...|
|00003c70| f8 01 00 10 f2 13 00 d9 | 0d 00 52 65 76 65 72 74 |........|..Revert|
|00003c80| 20 66 61 69 6c 65 64 f3 | 11 00 d9 0e 00 31 20 72 | failed.|.....1 r|
|00003c90| 6f 77 20 72 65 76 65 72 | 74 65 64 36 f4 00 00 f6 |ow rever|ted6....|
|00003ca0| 04 00 fd fe 0d 00 99 fc | 43 f4 00 00 f6 05 00 fd |........|C.......|
|00003cb0| fe 03 00 55 06 00 08 00 | 54 48 49 53 46 4f 52 4d |...U....|THISFORM|
|00003cc0| 0b 00 43 55 52 53 4f 52 | 41 4c 49 41 53 06 00 4c |..CURSOR|ALIAS..L|
|00003cd0| 4e 52 4f 57 53 0b 00 43 | 48 45 43 4b 53 4f 55 52 |NROWS..C|HECKSOUR|
|00003ce0| 43 45 05 00 41 4c 45 52 | 54 0c 00 4e 45 58 54 43 |CE..ALER|T..NEXTC|
|00003cf0| 4f 4e 46 4c 49 43 54 05 | 00 43 6c 69 63 6b 2c 00 |ONFLICT.|.Click,.|
|00003d00| 00 00 00 00 ff ff 31 00 | 21 01 41 02 71 00 41 00 |......1.|!.A.q.A.|
|00003d10| 72 00 e2 00 d1 00 d3 03 | d1 00 32 00 00 00 00 00 |r.......|..2.....|
|00003d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00003d30| 11 00 00 00 40 01 00 00 | 01 00 00 00 00 29 00 00 |....@...|.....)..|
|00003d40| 00 8f 01 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003d50| 00 00 00 00 00 00 00 00 | 01 00 00 00 09 63 6d 64 |........|.....cmd|
|00003d60| 52 65 76 65 72 74 00 00 | 00 01 00 00 05 2d 50 52 |Revert..|.....-PR|
|00003d70| 4f 43 45 44 55 52 45 20 | 43 6c 69 63 6b 0d 0a 4c |OCEDURE |Click..L|
|00003d80| 4f 43 41 4c 20 63 46 69 | 6c 74 65 72 2c 6e 43 6e |OCAL cFi|lter,nCn|
|00003d90| 74 2c 63 43 6f 6e 64 69 | 74 69 6f 6e 0d 0a 63 46 |t,cCondi|tion..cF|
|00003da0| 69 6c 74 65 72 20 3d 20 | 22 22 0d 0a 0d 0a 2a 21 |ilter = |""....*!|
|00003db0| 2a 20 46 69 72 73 74 2c | 20 77 65 20 6e 65 65 64 |* First,| we need|
|00003dc0| 20 74 6f 20 77 61 6c 6b | 20 61 6c 6c 20 74 68 65 | to walk| all the|
|00003dd0| 20 63 6f 6e 74 72 6f 6c | 73 20 6f 6e 20 74 68 65 | control|s on the|
|00003de0| 20 66 6f 72 6d 20 61 6e | 64 20 66 69 6e 64 0d 0a | form an|d find..|
|00003df0| 2a 21 2a 20 61 6c 6c 20 | 63 6f 6e 74 72 6f 6c 73 |*!* all |controls|
|00003e00| 20 77 69 74 68 20 61 20 | 63 6f 6e 74 72 6f 6c 53 | with a |controlS|
|00003e10| 6f 75 72 63 65 20 61 6e | 64 20 68 61 73 20 61 20 |ource an|d has a |
|00003e20| 76 61 6c 75 65 20 69 6e | 20 74 68 65 20 76 61 6c |value in| the val|
|00003e30| 75 65 20 70 72 6f 70 65 | 72 74 79 2e 0d 0a 0d 0a |ue prope|rty.....|
|00003e40| 46 4f 52 20 6e 43 6e 74 | 20 3d 20 31 20 74 6f 20 |FOR nCnt| = 1 to |
|00003e50| 54 48 49 53 46 4f 52 4d | 2e 43 6f 6e 74 72 6f 6c |THISFORM|.Control|
|00003e60| 43 6f 75 6e 74 0d 0a 09 | 49 46 20 54 59 50 45 28 |Count...|IF TYPE(|
|00003e70| 27 54 48 49 53 46 4f 52 | 4d 2e 43 6f 6e 74 72 6f |'THISFOR|M.Contro|
|00003e80| 6c 73 28 6e 43 6e 74 29 | 2e 63 6f 6e 74 72 6f 6c |ls(nCnt)|.control|
|00003e90| 53 6f 75 72 63 65 27 29 | 20 3c 3e 20 22 55 22 20 |Source')| <> "U" |
|00003ea0| 54 48 45 4e 0d 0a 09 09 | 49 46 20 21 45 4d 50 54 |THEN....|IF !EMPT|
|00003eb0| 59 28 54 48 49 53 46 4f | 52 4d 2e 43 6f 6e 74 72 |Y(THISFO|RM.Contr|
|00003ec0| 6f 6c 73 28 6e 43 6e 74 | 29 2e 43 6f 6e 74 72 6f |ols(nCnt|).Contro|
|00003ed0| 6c 53 6f 75 72 63 65 29 | 20 41 4e 44 20 3b 0d 0a |lSource)| AND ;..|
|00003ee0| 09 09 20 20 54 59 50 45 | 28 27 54 48 49 53 46 4f |.. TYPE|('THISFO|
|00003ef0| 52 4d 2e 43 6f 6e 74 72 | 6f 6c 73 28 6e 43 6e 74 |RM.Contr|ols(nCnt|
|00003f00| 29 2e 76 61 6c 75 65 27 | 29 20 3c 3e 20 22 55 22 |).value'|) <> "U"|
|00003f10| 20 54 48 45 4e 0d 0a 09 | 09 20 20 0d 0a 09 09 20 | THEN...|. .... |
|00003f20| 20 20 20 2a 21 2a 20 4e | 6f 77 20 77 65 20 6e 65 | *!* N|ow we ne|
|00003f30| 65 64 20 74 6f 20 70 61 | 72 73 65 20 74 68 65 20 |ed to pa|rse the |
|00003f40| 76 61 6c 75 65 20 70 72 | 6f 70 65 72 74 79 20 69 |value pr|operty i|
|00003f50| 6e 74 6f 20 61 20 70 72 | 6f 70 65 72 0d 0a 09 09 |nto a pr|oper....|
|00003f60| 20 20 20 20 2a 21 2a 20 | 63 6f 6e 64 69 74 69 6f | *!* |conditio|
|00003f70| 6e 20 75 73 69 6e 67 20 | 74 68 65 20 70 61 72 73 |n using |the pars|
|00003f80| 65 43 6f 6e 64 69 74 69 | 6f 6e 20 6d 65 74 68 6f |eConditi|on metho|
|00003f90| 64 20 6f 66 20 74 68 65 | 20 66 6f 72 6d 0d 0a 09 |d of the| form...|
|00003fa0| 09 09 63 43 6f 6e 64 69 | 74 69 6f 6e 20 3d 20 54 |..cCondi|tion = T|
|00003fb0| 48 49 53 2e 50 61 72 65 | 6e 74 2e 70 61 72 73 65 |HIS.Pare|nt.parse|
|00003fc0| 43 6f 6e 64 69 74 69 6f | 6e 28 54 48 49 53 46 4f |Conditio|n(THISFO|
|00003fd0| 52 4d 2e 43 6f 6e 74 72 | 6f 6c 73 28 6e 43 6e 74 |RM.Contr|ols(nCnt|
|00003fe0| 29 2e 76 61 6c 75 65 2c | 54 48 49 53 46 4f 52 4d |).value,|THISFORM|
|00003ff0| 2e 43 6f 6e 74 72 6f 6c | 73 28 6e 43 6e 74 29 2e |.Control|s(nCnt).|
|00004000| 63 6f 6e 74 72 6f 6c 53 | 6f 75 72 63 65 29 0d 0a |controlS|ource)..|
|00004010| 09 09 09 0d 0a 09 09 09 | 2a 21 2a 20 49 66 20 74 |........|*!* If t|
|00004020| 68 65 72 65 20 69 73 20 | 61 20 63 6f 6e 64 69 74 |here is |a condit|
|00004030| 69 6f 6e 2c 20 61 64 64 | 20 69 74 20 74 6f 20 61 |ion, add| it to a|
|00004040| 72 65 20 6f 76 65 72 61 | 6c 6c 20 66 69 6c 74 65 |re overa|ll filte|
|00004050| 72 0d 0a 09 09 09 49 46 | 20 21 45 4d 50 54 59 28 |r.....IF| !EMPTY(|
|00004060| 63 43 6f 6e 64 69 74 69 | 6f 6e 29 20 54 48 45 4e |cConditi|on) THEN|
|00004070| 0d 0a 09 09 09 09 63 46 | 69 6c 74 65 72 20 3d 20 |......cF|ilter = |
|00004080| 63 46 69 6c 74 65 72 20 | 2b 20 22 20 41 4e 44 20 |cFilter |+ " AND |
|00004090| 22 20 2b 20 63 43 6f 6e | 64 69 74 69 6f 6e 0d 0a |" + cCon|dition..|
|000040a0| 09 09 09 45 4e 44 49 46 | 0d 0a 09 09 45 4e 44 49 |...ENDIF|....ENDI|
|000040b0| 46 0d 0a 09 45 4e 44 49 | 46 0d 0a 45 4e 44 46 4f |F...ENDI|F..ENDFO|
|000040c0| 52 0d 0a 0d 0a 2a 21 2a | 20 57 65 20 6e 65 65 64 |R....*!*| We need|
|000040d0| 20 74 6f 20 72 6f 6c 6c | 62 61 63 6b 20 74 68 65 | to roll|back the|
|000040e0| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 20 74 6f 20 | transac|tion to |
|000040f0| 64 69 73 63 61 72 64 20 | 74 68 65 20 41 50 50 45 |discard |the APPE|
|00004100| 4e 44 27 65 64 20 72 65 | 63 6f 72 64 0d 0a 52 4f |ND'ed re|cord..RO|
|00004110| 4c 4c 42 41 43 4b 0d 0a | 0d 0a 54 48 49 53 2e 45 |LLBACK..|..THIS.E|
|00004120| 6e 61 62 6c 65 64 20 3d | 20 2e 46 2e 0d 0a 54 48 |nabled =| .F...TH|
|00004130| 49 53 2e 50 61 72 65 6e | 74 2e 63 6d 64 51 42 46 |IS.Paren|t.cmdQBF|
|00004140| 4d 6f 64 65 2e 45 6e 61 | 62 6c 65 64 20 3d 20 2e |Mode.Ena|bled = .|
|00004150| 54 2e 0d 0a 0d 0a 2a 21 | 2a 20 54 68 69 73 20 72 |T.....*!|* This r|
|00004160| 65 6d 6f 76 65 73 20 74 | 68 65 20 22 20 41 4e 44 |emoves t|he " AND|
|00004170| 20 22 20 6b 65 79 77 6f | 72 64 20 74 68 61 74 20 | " keywo|rd that |
|00004180| 69 73 20 6e 6f 74 20 6e | 65 65 64 65 64 20 66 6f |is not n|eeded fo|
|00004190| 72 20 74 68 65 20 0d 0a | 2a 21 2a 20 66 69 72 73 |r the ..|*!* firs|
|000041a0| 74 20 63 6f 6e 64 69 74 | 69 6f 6e 20 61 64 64 65 |t condit|ion adde|
|000041b0| 64 20 74 6f 20 63 46 69 | 6c 74 65 72 0d 0a 49 46 |d to cFi|lter..IF|
|000041c0| 20 21 45 4d 50 54 59 28 | 63 46 69 6c 74 65 72 29 | !EMPTY(|cFilter)|
|000041d0| 20 54 48 45 4e 0d 0a 09 | 63 46 69 6c 74 65 72 20 | THEN...|cFilter |
|000041e0| 3d 20 41 4c 4c 54 52 49 | 4d 28 53 55 42 53 54 52 |= ALLTRI|M(SUBSTR|
|000041f0| 43 28 63 46 69 6c 74 65 | 72 2c 35 29 29 0d 0a 45 |C(cFilte|r,5))..E|
|00004200| 4e 44 49 46 0d 0a 0d 0a | 2a 21 2a 20 4e 6f 77 20 |NDIF....|*!* Now |
|00004210| 77 65 20 61 72 65 20 72 | 65 61 64 79 20 74 6f 20 |we are r|eady to |
|00004220| 61 70 70 6c 79 20 74 68 | 65 20 66 69 6c 74 65 72 |apply th|e filter|
|00004230| 0d 0a 53 45 54 20 46 49 | 4c 54 45 52 20 54 4f 20 |..SET FI|LTER TO |
|00004240| 26 63 46 69 6c 74 65 72 | 0d 0a 0d 0a 54 48 49 53 |&cFilter|....THIS|
|00004250| 2e 50 61 72 65 6e 74 2e | 63 6d 64 43 6c 65 61 72 |.Parent.|cmdClear|
|00004260| 46 69 6c 74 65 72 2e 65 | 6e 61 62 6c 65 64 20 3d |Filter.e|nabled =|
|00004270| 20 2e 54 2e 0d 0a 0d 0a | 47 4f 20 54 4f 50 0d 0a | .T.....|GO TOP..|
|00004280| 54 48 49 53 46 4f 52 4d | 2e 52 65 66 72 65 73 68 |THISFORM|.Refresh|
|00004290| 0d 0a 45 4e 44 50 52 4f | 43 0d 0a 00 00 00 01 00 |..ENDPRO|C.......|
|000042a0| 00 01 4b 50 52 4f 43 45 | 44 55 52 45 20 43 6c 69 |..KPROCE|DURE Cli|
|000042b0| 63 6b 0d 0a 49 46 20 45 | 4d 50 54 59 28 54 48 49 |ck..IF E|MPTY(THI|
|000042c0| 53 46 4f 52 4d 2e 43 75 | 72 73 6f 72 41 6c 69 61 |SFORM.Cu|rsorAlia|
|000042d0| 73 29 0d 0a 09 57 41 49 | 54 20 57 49 4e 44 4f 57 |s)...WAI|T WINDOW|
|000042e0| 20 43 53 5f 4e 4f 41 4c | 49 41 53 5f 4c 4f 43 20 | CS_NOAL|IAS_LOC |
|000042f0| 54 49 4d 45 4f 55 54 20 | 32 0d 0a 09 52 45 54 55 |TIMEOUT |2...RETU|
|00004300| 52 4e 20 2e 46 2e 0d 0a | 45 4e 44 49 46 0d 0a 0d |RN .F...|ENDIF...|
|00004310| 0a 4c 4f 43 41 4c 20 6c | 6e 52 6f 77 73 20 0d 0a |.LOCAL l|nRows ..|
|00004320| 0d 0a 6c 6e 52 6f 77 73 | 20 3d 20 54 41 42 4c 45 |..lnRows| = TABLE|
|00004330| 52 45 56 45 52 54 28 2e | 46 2e 29 0d 0a 54 48 49 |REVERT(.|F.)..THI|
|00004340| 53 46 4f 52 4d 2e 43 68 | 65 63 6b 53 6f 75 72 63 |SFORM.Ch|eckSourc|
|00004350| 65 28 29 0d 0a 0d 0a 2a | 20 6e 6f 20 63 6f 6e 66 |e()....*| no conf|
|00004360| 6c 69 63 74 73 2c 20 6e | 6f 20 72 6f 77 20 6f 72 |licts, n|o row or|
|00004370| 20 6f 6e 65 20 72 6f 77 | 20 72 65 76 65 72 74 65 | one row| reverte|
|00004380| 64 0d 0a 54 48 49 53 46 | 4f 52 4d 2e 41 6c 65 72 |d..THISF|ORM.Aler|
|00004390| 74 28 20 49 49 46 28 6c | 6e 52 6f 77 73 20 3d 20 |t( IIF(l|nRows = |
|000043a0| 30 2c 57 41 49 54 5f 52 | 45 56 45 52 54 46 41 49 |0,WAIT_R|EVERTFAI|
|000043b0| 4c 5f 4c 4f 43 2c 57 41 | 49 54 5f 52 45 56 45 52 |L_LOC,WA|IT_REVER|
|000043c0| 54 31 5f 4c 4f 43 29 29 | 0d 0a 54 48 49 53 46 4f |T1_LOC))|..THISFO|
|000043d0| 52 4d 2e 4e 65 78 74 43 | 6f 6e 66 6c 69 63 74 28 |RM.NextC|onflict(|
|000043e0| 29 0d 0a 0d 0a 45 4e 44 | 50 52 4f 43 0d 0a 00 00 |)....END|PROC....|
|000043f0| 00 01 00 00 00 5a 54 6f | 70 20 3d 20 31 34 39 0d |.....ZTo|p = 149.|
|00004400| 0a 4c 65 66 74 20 3d 20 | 32 36 32 0d 0a 48 65 69 |.Left = |262..Hei|
|00004410| 67 68 74 20 3d 20 32 33 | 0d 0a 57 69 64 74 68 20 |ght = 23|..Width |
|00004420| 3d 20 37 32 0d 0a 43 61 | 70 74 69 6f 6e 20 3d 20 |= 72..Ca|ption = |
|00004430| 22 5c 3c 52 65 76 65 72 | 74 22 0d 0a 4e 61 6d 65 |"\<Rever|t"..Name|
|00004440| 20 3d 20 22 63 6d 64 52 | 65 76 65 72 74 22 0d 0a | = "cmdR|evert"..|
|00004450| 00 00 00 01 00 00 00 09 | 5f 62 61 73 65 2e 76 63 |........|_base.vc|
|00004460| 78 00 00 00 01 00 00 05 | 71 fe f2 ff 20 02 01 00 |x.......|q... ...|
|00004470| 00 00 58 05 00 00 58 05 | 00 00 00 00 00 00 00 00 |..X...X.|........|
|00004480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004490| 4b 8f 06 00 00 00 25 00 | 00 00 f5 03 00 00 00 00 |K.....%.|........|
|000044a0| 00 00 bf 04 00 00 32 00 | 00 00 5b 04 00 00 00 00 |......2.|..[.....|
|000044b0| 00 00 00 00 00 00 fc 03 | 00 03 00 55 00 00 48 00 |........|...U..H.|
|000044c0| 07 00 ae f7 00 00 fe 1f | 00 54 f7 00 00 10 fc 43 |........|.T.....C|
|000044d0| f4 01 00 f7 02 00 f4 01 | 00 f7 03 00 f4 01 00 f7 |........|........|
|000044e0| 04 00 ea 69 fd fe 11 00 | 25 fc f7 00 00 f8 01 00 |...i....|%.......|
|000044f0| 0d fd f9 05 41 00 fe 0a | 00 99 f4 01 00 f7 05 00 |....A...|........|
|00004500| fe 04 00 1e fe 03 00 55 | 06 00 06 00 4e 45 52 52 |.......U|....NERR|
|00004510| 4f 52 04 00 54 48 49 53 | 0e 00 48 43 4f 4e 4e 45 |OR..THIS|..HCONNE|
|00004520| 43 54 48 41 4e 44 4c 45 | 04 00 43 53 51 4c 0b 00 |CTHANDLE|..CSQL..|
|00004530| 43 43 55 52 53 4f 52 4e | 41 4d 45 0c 00 50 52 4f |CCURSORN|AME..PRO|
|00004540| 43 45 53 53 45 52 52 4f | 52 78 00 10 00 25 fc f4 |CESSERRO|Rx...%..|
|00004550| 00 00 f7 01 00 fd f9 05 | 39 00 fe 29 00 54 f4 00 |........|9..).T..|
|00004560| 00 f7 02 00 10 fc d9 05 | 00 65 78 65 63 20 f4 00 |........|.exec ..|
|00004570| 00 f7 03 00 06 d9 01 00 | 20 06 43 f4 00 00 f6 04 |........| .C.....|
|00004580| 00 06 fd fe 08 00 1b f9 | 05 71 00 fe 30 00 54 f4 |........|.q..0.T.|
|00004590| 00 00 f7 02 00 10 fc d9 | 06 00 7b 63 61 6c 6c 20 |........|..{call |
|000045a0| f4 00 00 f7 03 00 06 d9 | 01 00 28 06 43 f4 00 00 |........|..(.C...|
|000045b0| f6 04 00 06 d9 02 00 29 | 7d 06 fd fe 04 00 1e fe |.......)|}.......|
|000045c0| 03 00 55 05 00 04 00 54 | 48 49 53 0d 00 4c 55 53 |..U....T|HIS..LUS|
|000045d0| 45 53 51 4c 53 59 4e 54 | 41 58 04 00 43 53 51 4c |ESQLSYNT|AX..CSQL|
|000045e0| 07 00 43 53 50 4e 41 4d | 45 09 00 53 45 54 50 41 |..CSPNAM|E..SETPA|
|000045f0| 52 41 4d 53 89 00 0b 00 | ae f7 00 00 07 f7 01 00 |RAMS....|........|
|00004600| fe 0d 00 54 f7 01 00 10 | fc d9 00 00 fd fe 1c 00 |...T....|........|
|00004610| 84 f7 00 00 10 fc f8 01 | 01 fd 28 fc 43 f4 02 00 |........|..(.C...|
|00004620| e0 03 00 cd fd f9 05 79 | 00 fe 19 00 54 f7 01 00 |.......y|....T...|
|00004630| 10 fc f7 01 00 43 00 f7 | 00 00 f4 02 00 f6 03 00 |.....C..|........|
|00004640| 06 fd fe 16 00 25 fc f7 | 00 00 43 f4 02 00 e0 03 |.....%..|..C.....|
|00004650| 00 cd 0f fd f9 05 75 00 | fe 12 00 54 f7 01 00 10 |......u.|...T....|
|00004660| fc f7 01 00 fb 01 00 2c | 06 fd fe 04 00 1e fe 04 |.......,|........|
|00004670| 00 85 fe 09 00 42 fc f7 | 01 00 fd fe 03 00 55 04 |.....B..|......U.|
|00004680| 00 0b 00 4e 41 52 52 41 | 59 43 4f 55 4e 54 06 00 |...NARRA|YCOUNT..|
|00004690| 43 50 41 52 4d 53 04 00 | 54 48 49 53 07 00 41 50 |CPARMS..|THIS..AP|
|000046a0| 41 52 41 4d 53 45 00 07 | 00 ae f7 00 00 fe 0d 00 |ARAMSE..|........|
|000046b0| 15 f6 01 00 fc f8 01 05 | fd 16 fe 0e 00 86 fc 43 |........|.......C|
|000046c0| ea 19 f7 01 00 ea 7a fd | fe 14 00 54 f7 00 00 10 |......z.|...T....|
|000046d0| fc 43 f8 01 01 f8 01 02 | f6 01 00 fd fe 0c 00 86 |.C......|........|
|000046e0| fc 43 f7 00 00 ea 78 fd | fe 03 00 55 02 00 0c 00 |.C....x.|...U....|
|000046f0| 43 4d 45 53 53 41 47 45 | 54 45 58 54 09 00 41 53 |CMESSAGE|TEXT..AS|
|00004700| 51 4c 45 52 52 4f 52 0f | 00 0c 00 42 fc f4 00 00 |QLERROR.|...B....|
|00004710| f7 01 00 fd fe 03 00 55 | 02 00 04 00 54 48 49 53 |.......U|....THIS|
|00004720| 04 00 43 53 51 4c 20 01 | 13 00 34 f7 00 00 07 f7 |..CSQL .|..4.....|
|00004730| 01 00 07 f7 02 00 07 f7 | 03 00 fe 10 00 25 fc 43 |........|.....%.C|
|00004740| c4 f8 01 03 0d fd f9 05 | 68 00 fe 3e 00 99 fc 43 |........|h..>...C|
|00004750| d9 32 00 59 6f 75 20 6d | 75 73 74 20 70 61 73 73 |.2.You m|ust pass|
|00004760| 20 61 74 20 6c 65 61 73 | 74 20 33 20 70 61 72 61 | at leas|t 3 para|
|00004770| 6d 65 74 65 72 73 20 74 | 6f 20 74 68 69 73 20 63 |meters t|o this c|
|00004780| 6c 61 73 73 2e ea 78 fd | fe 07 00 42 fc 2d fd fe |lass..x.|...B.-..|
|00004790| 04 00 1e fe 10 00 15 f4 | 04 00 f6 02 00 fc f8 01 |........|........|
|000047a0| 01 fd 16 fe 13 00 99 fc | 43 eb f7 02 00 f4 04 00 |........|C.......|
|000047b0| e0 02 00 ea 0d fd fe 12 | 00 25 fc 43 f5 0d f7 00 |........|.%.C....|
|000047c0| 00 a1 0a fd f9 05 b3 00 | fe 12 00 54 f4 04 00 f7 |........|...T....|
|000047d0| 00 00 10 fc f5 0d f7 00 | 00 fd fe 04 00 1e fe 12 |........|........|
|000047e0| 00 54 f4 04 00 f7 01 00 | 10 fc f5 0d f7 01 00 fd |.T......|........|
|000047f0| fe 10 00 25 fc 43 c4 f8 | 01 03 10 fd f9 05 f2 00 |...%.C..|........|
|00004800| fe 19 00 54 f4 04 00 f7 | 03 00 10 fc fb 09 00 73 |...T....|.......s|
|00004810| 71 6c 72 65 73 75 6c 74 | fd fe 08 00 1b f9 05 0c |qlresult|........|
|00004820| 01 fe 12 00 54 f4 04 00 | f7 03 00 10 fc f5 0d f7 |....T...|........|
|00004830| 03 00 fd fe 04 00 1e fe | 0d 00 99 fc 43 f4 04 00 |........|....C...|
|00004840| f6 05 00 fd fe 03 00 55 | 06 00 07 00 43 53 50 4e |.......U|....CSPN|
|00004850| 41 4d 45 0e 00 48 43 4f | 4e 4e 45 43 54 48 41 4e |AME..HCO|NNECTHAN|
|00004860| 44 4c 45 07 00 41 50 41 | 52 41 4d 53 0b 00 43 43 |DLE..APA|RAMS..CC|
|00004870| 55 52 53 4f 52 4e 41 4d | 45 04 00 54 48 49 53 06 |URSORNAM|E..THIS.|
|00004880| 00 53 45 54 53 51 4c 05 | 00 64 6f 73 71 6c 2c 00 |.SETSQL.|.dosql,.|
|00004890| 00 00 00 00 ff ff 06 00 | 73 65 74 73 71 6c b7 00 |........|setsql..|
|000048a0| 00 00 00 00 ff ff 09 00 | 73 65 74 70 61 72 61 6d |........|setparam|
|000048b0| 73 62 01 00 00 00 00 ff | ff 0c 00 70 72 6f 63 65 |sb......|...proce|
|000048c0| 73 73 65 72 72 6f 72 13 | 02 00 00 00 00 ff ff 06 |sserror.|........|
|000048d0| 00 67 65 74 73 71 6c 75 | 02 00 00 00 00 ff ff 04 |.getsqlu|........|
|000048e0| 00 49 6e 69 74 94 02 00 | 00 00 00 ff ff 31 00 71 |.Init...|.....1.q|
|000048f0| 00 f1 01 11 01 a1 00 41 | 00 33 00 01 01 91 02 81 |.......A|.3......|
|00004900| 00 01 03 41 00 33 00 b1 | 00 d1 00 c1 01 91 01 61 |...A.3..|.......a|
|00004910| 01 21 01 41 00 41 00 91 | 00 32 00 71 00 d1 00 e2 |.!.A.A..|.2.q....|
|00004920| 00 41 01 c1 00 33 00 c1 | 00 33 00 f0 00 31 01 02 |.A...3..|.3...1..|
|00004930| 01 e1 03 71 00 41 00 02 | 01 31 01 22 01 21 01 41 |...q.A..|.1.".!.A|
|00004940| 00 22 01 02 01 91 01 81 | 00 21 01 41 00 d2 00 32 |."......|.!.A...2|
|00004950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004960| 00 01 00 00 00 11 00 00 | 00 8e 00 00 00 01 00 00 |........|........|
|00004970| 00 07 00 00 00 ab 00 00 | 00 64 01 00 00 09 00 00 |........|.d......|
|00004980| 00 0d 00 00 00 84 01 00 | 00 60 02 00 00 11 00 00 |........|.`......|
|00004990| 00 17 00 00 00 83 02 00 | 00 01 03 00 00 1c 00 00 |........|........|
|000049a0| 00 1d 00 00 00 1e 03 00 | 00 30 03 00 00 25 00 00 |........|.0...%..|
|000049b0| 00 1f 00 00 00 4b 03 00 | 00 4f 07 00 00 29 00 00 |.....K..|.O...)..|
|000049c0| 00 00 29 00 00 00 58 05 | 00 00 00 00 00 00 00 00 |..)...X.|........|
|000049d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|000049e0| 07 5a 50 52 4f 43 45 44 | 55 52 45 20 64 6f 73 71 |.ZPROCED|URE dosq|
|000049f0| 6c 0d 0a 4c 4f 43 41 4c | 20 6e 45 72 72 6f 72 0d |l..LOCAL| nError.|
|00004a00| 0a 6e 45 72 72 6f 72 20 | 3d 20 53 51 4c 45 58 45 |.nError |= SQLEXE|
|00004a10| 43 20 28 74 68 69 73 2e | 68 43 6f 6e 6e 65 63 74 |C (this.|hConnect|
|00004a20| 48 61 6e 64 6c 65 2c 20 | 74 68 69 73 2e 63 53 51 |Handle, |this.cSQ|
|00004a30| 4c 2c 20 74 68 69 73 2e | 63 43 75 72 73 6f 72 4e |L, this.|cCursorN|
|00004a40| 61 6d 65 29 0d 0a 49 46 | 20 6e 45 72 72 6f 72 20 |ame)..IF| nError |
|00004a50| 3c 20 30 0d 0a 09 74 68 | 69 73 2e 50 72 6f 63 65 |< 0...th|is.Proce|
|00004a60| 73 73 45 72 72 6f 72 0d | 0a 45 4e 44 49 46 0d 0a |ssError.|.ENDIF..|
|00004a70| 0d 0a 45 4e 44 50 52 4f | 43 0d 0a 50 52 4f 43 45 |..ENDPRO|C..PROCE|
|00004a80| 44 55 52 45 20 73 65 74 | 73 71 6c 0d 0a 49 46 20 |DURE set|sql..IF |
|00004a90| 54 48 49 53 2e 6c 55 73 | 65 53 51 4c 53 79 6e 74 |THIS.lUs|eSQLSynt|
|00004aa0| 61 78 0d 0a 09 54 48 49 | 53 2e 63 53 51 4c 20 3d |ax...THI|S.cSQL =|
|00004ab0| 20 22 65 78 65 63 20 22 | 20 2b 20 74 68 69 73 2e | "exec "| + this.|
|00004ac0| 63 53 50 4e 61 6d 65 09 | 2b 22 20 22 20 2b 74 68 |cSPName.|+" " +th|
|00004ad0| 69 73 2e 53 65 74 50 61 | 72 61 6d 73 28 29 20 26 |is.SetPa|rams() &|
|00004ae0| 26 53 51 4c 20 53 65 72 | 76 65 72 20 73 70 65 63 |&SQL Ser|ver spec|
|00004af0| 69 66 69 63 0d 0a 45 4c | 53 45 0d 0a 09 54 48 49 |ific..EL|SE...THI|
|00004b00| 53 2e 63 53 51 4c 20 3d | 20 22 7b 63 61 6c 6c 20 |S.cSQL =| "{call |
|00004b10| 22 20 2b 20 74 68 69 73 | 2e 63 53 50 4e 61 6d 65 |" + this|.cSPName|
|00004b20| 20 2b 20 22 28 22 2b 74 | 68 69 73 2e 53 65 74 50 | + "("+t|his.SetP|
|00004b30| 61 72 61 6d 73 28 29 2b | 20 22 29 7d 22 0d 0a 45 |arams()+| ")}"..E|
|00004b40| 4e 44 49 46 0d 0a 0d 0a | 45 4e 44 50 52 4f 43 0d |NDIF....|ENDPROC.|
|00004b50| 0a 50 52 4f 43 45 44 55 | 52 45 20 73 65 74 70 61 |.PROCEDU|RE setpa|
|00004b60| 72 61 6d 73 0d 0a 4c 4f | 43 41 4c 20 6e 41 72 72 |rams..LO|CAL nArr|
|00004b70| 61 79 43 6f 75 6e 74 2c | 63 50 61 72 6d 73 0d 0a |ayCount,|cParms..|
|00004b80| 63 50 61 72 6d 73 3d 22 | 22 0d 0a 46 4f 52 20 6e |cParms="|"..FOR n|
|00004b90| 41 72 72 61 79 43 6f 75 | 6e 74 20 3d 20 31 20 54 |ArrayCou|nt = 1 T|
|00004ba0| 4f 20 41 4c 45 4e 20 28 | 74 68 69 73 2e 61 50 61 |O ALEN (|this.aPa|
|00004bb0| 72 61 6d 73 29 0d 0a 09 | 63 50 61 72 6d 73 20 3d |rams)...|cParms =|
|00004bc0| 20 63 50 61 72 6d 73 20 | 2b 20 74 68 69 73 2e 61 | cParms |+ this.a|
|00004bd0| 50 61 72 61 6d 73 5b 6e | 41 72 72 61 79 43 6f 75 |Params[n|ArrayCou|
|00004be0| 6e 74 5d 0d 0a 09 49 46 | 20 6e 41 72 72 61 79 43 |nt]...IF| nArrayC|
|00004bf0| 6f 75 6e 74 20 3c 3e 20 | 41 4c 45 4e 20 28 74 68 |ount <> |ALEN (th|
|00004c00| 69 73 2e 61 50 61 72 61 | 6d 73 29 0d 0a 09 09 63 |is.aPara|ms)....c|
|00004c10| 50 61 72 6d 73 3d 20 63 | 50 61 72 6d 73 20 2b 20 |Parms= c|Parms + |
|00004c20| 27 2c 27 0d 0a 09 45 4e | 44 49 46 0d 0a 45 4e 44 |','...EN|DIF..END|
|00004c30| 46 4f 52 0d 0a 52 45 54 | 55 52 4e 20 63 50 61 72 |FOR..RET|URN cPar|
|00004c40| 6d 73 0d 0a 45 4e 44 50 | 52 4f 43 0d 0a 50 52 4f |ms..ENDP|ROC..PRO|
|00004c50| 43 45 44 55 52 45 20 70 | 72 6f 63 65 73 73 65 72 |CEDURE p|rocesser|
|00004c60| 72 6f 72 0d 0a 4c 4f 43 | 41 4c 20 63 4d 65 73 73 |ror..LOC|AL cMess|
|00004c70| 61 67 65 54 65 78 74 0d | 0a 44 49 4d 45 4e 53 49 |ageText.|.DIMENSI|
|00004c80| 4f 4e 20 61 53 51 4c 45 | 72 72 6f 72 5b 35 5d 0d |ON aSQLE|rror[5].|
|00004c90| 0a 0d 0a 3d 41 45 52 52 | 4f 52 20 28 61 53 51 4c |...=AERR|OR (aSQL|
|00004ca0| 45 72 72 6f 72 29 0d 0a | 63 4d 65 73 73 61 67 65 |Error)..|cMessage|
|00004cb0| 54 65 78 74 20 3d 20 61 | 53 51 4c 45 72 72 6f 72 |Text = a|SQLError|
|00004cc0| 5b 31 2c 32 5d 0d 0a 3d | 4d 45 53 53 41 47 45 42 |[1,2]..=|MESSAGEB|
|00004cd0| 4f 58 20 28 63 4d 65 73 | 73 61 67 65 54 65 78 74 |OX (cMes|sageText|
|00004ce0| 29 0d 0a 0d 0a 45 4e 44 | 50 52 4f 43 0d 0a 50 52 |)....END|PROC..PR|
|00004cf0| 4f 43 45 44 55 52 45 20 | 67 65 74 73 71 6c 0d 0a |OCEDURE |getsql..|
|00004d00| 52 45 54 55 52 4e 20 74 | 68 69 73 2e 63 53 51 4c |RETURN t|his.cSQL|
|00004d10| 0d 0a 0d 0a 45 4e 44 50 | 52 4f 43 0d 0a 50 52 4f |....ENDP|ROC..PRO|
|00004d20| 43 45 44 55 52 45 20 49 | 6e 69 74 0d 0a 2a 20 54 |CEDURE I|nit..* T|
|00004d30| 68 69 73 20 63 6c 61 73 | 73 20 6c 69 62 72 61 72 |his clas|s librar|
|00004d40| 79 20 69 73 20 75 73 65 | 64 20 66 6f 72 20 53 51 |y is use|d for SQ|
|00004d50| 4c 20 50 61 73 73 20 54 | 68 72 75 20 61 6e 64 20 |L Pass T|hru and |
|00004d60| 63 61 6e 20 61 6c 6c 6f | 77 20 79 6f 75 20 74 6f |can allo|w you to|
|00004d70| 20 65 78 65 63 75 74 65 | 20 73 74 6f 72 65 64 20 | execute| stored |
|00004d80| 70 72 6f 63 65 64 75 72 | 65 73 0d 0a 2a 20 6f 6e |procedur|es..* on|
|00004d90| 20 79 6f 75 72 20 68 6f | 73 74 20 64 61 74 61 62 | your ho|st datab|
|00004da0| 61 73 65 2e 20 46 6f 72 | 20 65 78 61 6d 70 6c 65 |ase. For| example|
|00004db0| 2c 20 74 68 65 20 73 61 | 6d 70 6c 65 20 62 65 6c |, the sa|mple bel|
|00004dc0| 6f 77 73 20 73 68 6f 77 | 73 20 68 6f 77 20 79 6f |ows show|s how yo|
|00004dd0| 75 20 6d 69 67 68 74 20 | 77 61 6e 74 20 74 6f 20 |u might |want to |
|00004de0| 63 61 6c 6c 65 64 20 61 | 20 73 74 6f 72 65 64 0d |called a| stored.|
|00004df0| 0a 2a 20 70 72 6f 63 65 | 64 75 72 65 20 63 61 6c |.* proce|dure cal|
|00004e00| 6c 65 64 20 22 55 70 64 | 61 74 65 41 75 74 68 6f |led "Upd|ateAutho|
|00004e10| 72 4e 61 6d 65 22 20 6f | 6e 20 74 68 65 20 64 61 |rName" o|n the da|
|00004e20| 74 61 62 61 73 65 20 22 | 70 75 62 73 22 2e 20 54 |tabase "|pubs". T|
|00004e30| 68 65 20 72 65 73 75 6c | 74 20 73 65 74 20 69 73 |he resul|t set is|
|00004e40| 20 72 65 74 75 72 6e 65 | 64 20 74 6f 20 61 20 63 | returne|d to a c|
|00004e50| 75 72 73 6f 72 2e 0d 0a | 0d 0a 2a 09 53 61 6d 70 |ursor...|..*.Samp|
|00004e60| 6c 65 20 63 6f 64 65 0d | 0a 2a 21 2a 09 73 71 6c |le code.|.*!*.sql|
|00004e70| 64 69 73 63 6f 6e 6e 28 | 30 29 0d 0a 2a 21 2a 09 |disconn(|0)..*!*.|
|00004e80| 44 49 4d 45 20 61 50 61 | 72 61 6d 73 5b 33 5d 0d |DIME aPa|rams[3].|
|00004e90| 0a 2a 21 2a 09 61 50 61 | 72 61 6d 73 5b 31 5d 20 |.*!*.aPa|rams[1] |
|00004ea0| 3d 20 22 27 31 37 32 2d | 33 32 2d 31 31 37 36 27 |= "'172-|32-1176'|
|00004eb0| 22 0d 0a 2a 21 2a 09 61 | 50 61 72 61 6d 73 5b 32 |"..*!*.a|Params[2|
|00004ec0| 5d 20 3d 20 22 27 53 27 | 22 0d 0a 2a 21 2a 09 61 |] = "'S'|"..*!*.a|
|00004ed0| 50 61 72 61 6d 73 5b 33 | 5d 20 3d 20 22 27 45 27 |Params[3|] = "'E'|
|00004ee0| 22 0d 0a 2a 21 2a 09 68 | 43 6f 6e 6e 65 63 74 20 |"..*!*.h|Connect |
|00004ef0| 3d 20 53 51 4c 43 4f 4e | 4e 45 43 54 20 28 27 70 |= SQLCON|NECT ('p|
|00004f00| 75 62 73 27 2c 27 73 61 | 27 2c 27 27 29 0d 0a 2a |ubs','sa|','')..*|
|00004f10| 21 2a 09 73 65 74 20 63 | 6c 61 73 73 6c 69 62 20 |!*.set c|lasslib |
|00004f20| 74 6f 20 48 4f 4d 45 28 | 29 2b 22 63 6c 61 73 73 |to HOME(|)+"class|
|00004f30| 65 73 5c 75 74 69 6c 69 | 74 79 2e 76 63 78 22 0d |es\utili|ty.vcx".|
|00004f40| 0a 2a 21 2a 09 78 3d 63 | 72 65 61 74 65 6f 62 6a |.*!*.x=c|reateobj|
|00004f50| 28 27 45 78 65 63 53 50 | 27 2c 20 27 55 70 64 61 |('ExecSP|', 'Upda|
|00004f60| 74 65 41 75 74 68 6f 72 | 4e 61 6d 65 27 2c 20 68 |teAuthor|Name', h|
|00004f70| 43 6f 6e 6e 65 63 74 2c | 20 40 61 50 61 72 61 6d |Connect,| @aParam|
|00004f80| 73 29 0d 0a 2a 21 2a 09 | 78 2e 64 6f 73 71 6c 28 |s)..*!*.|x.dosql(|
|00004f90| 29 0d 0a 0d 0a 50 41 52 | 41 4d 45 54 45 52 53 20 |)....PAR|AMETERS |
|00004fa0| 63 53 50 4e 61 6d 65 2c | 20 68 43 6f 6e 6e 65 63 |cSPName,| hConnec|
|00004fb0| 74 48 61 6e 64 6c 65 2c | 20 61 50 61 72 61 6d 73 |tHandle,| aParams|
|00004fc0| 2c 20 63 43 75 72 73 6f | 72 4e 61 6d 65 0d 0a 0d |, cCurso|rName...|
|00004fd0| 0a 49 46 20 50 41 52 41 | 4d 45 54 45 52 53 28 29 |.IF PARA|METERS()|
|00004fe0| 20 3c 20 33 0d 0a 09 4d | 45 53 53 41 47 45 42 4f | < 3...M|ESSAGEBO|
|00004ff0| 58 28 42 41 44 50 41 52 | 4d 53 5f 4c 4f 43 29 0d |X(BADPAR|MS_LOC).|
|00005000| 0a 09 52 45 54 55 52 4e | 20 2e 46 2e 0d 0a 45 4e |..RETURN| .F...EN|
|00005010| 44 49 46 0d 0a 0d 0a 44 | 49 4d 45 4e 53 49 4f 4e |DIF....D|IMENSION|
|00005020| 20 74 68 69 73 2e 61 50 | 61 72 61 6d 73 5b 31 5d | this.aP|arams[1]|
|00005030| 0d 0a 41 43 4f 50 59 28 | 61 50 61 72 61 6d 73 2c |..ACOPY(|aParams,|
|00005040| 74 68 69 73 2e 61 50 61 | 72 61 6d 73 29 0d 0a 0d |this.aPa|rams)...|
|00005050| 0a 49 46 20 4e 4f 54 20 | 45 4d 50 54 59 20 28 6d |.IF NOT |EMPTY (m|
|00005060| 2e 63 53 50 4e 61 6d 65 | 29 0d 0a 09 74 68 69 73 |.cSPName|)...this|
|00005070| 2e 63 53 50 4e 61 6d 65 | 20 3d 20 6d 2e 63 53 50 |.cSPName| = m.cSP|
|00005080| 4e 61 6d 65 0d 0a 45 4e | 44 49 46 0d 0a 0d 0a 74 |Name..EN|DIF....t|
|00005090| 68 69 73 2e 68 43 6f 6e | 6e 65 63 74 48 61 6e 64 |his.hCon|nectHand|
|000050a0| 6c 65 20 3d 20 6d 2e 68 | 43 6f 6e 6e 65 63 74 48 |le = m.h|ConnectH|
|000050b0| 61 6e 64 6c 65 0d 0a 0d | 0a 49 46 20 50 41 52 41 |andle...|.IF PARA|
|000050c0| 4d 45 54 45 52 53 20 28 | 29 20 3d 20 33 0d 0a 09 |METERS (|) = 3...|
|000050d0| 74 68 69 73 2e 63 43 75 | 72 73 6f 72 4e 61 6d 65 |this.cCu|rsorName|
|000050e0| 20 3d 20 27 73 71 6c 72 | 65 73 75 6c 74 27 0d 0a | = 'sqlr|esult'..|
|000050f0| 45 4c 53 45 0d 0a 09 74 | 68 69 73 2e 63 43 75 72 |ELSE...t|his.cCur|
|00005100| 73 6f 72 4e 61 6d 65 20 | 3d 20 6d 2e 63 43 75 72 |sorName |= m.cCur|
|00005110| 73 6f 72 4e 61 6d 65 0d | 0a 45 4e 44 49 46 0d 0a |sorName.|.ENDIF..|
|00005120| 0d 0a 74 68 69 73 2e 53 | 65 74 53 51 4c 28 29 0d |..this.S|etSQL().|
|00005130| 0a 0d 0a 45 4e 44 50 52 | 4f 43 0d 0a 00 00 00 01 |...ENDPR|OC......|
|00005140| 00 00 00 0d 63 6f 6d 6d | 61 6e 64 62 75 74 74 6f |....comm|andbutto|
|00005150| 6e 00 00 00 01 00 00 00 | 0e 5f 63 6f 6d 6d 61 6e |n.......|._comman|
|00005160| 64 62 75 74 74 6f 6e 00 | 00 00 01 00 00 01 e7 fe |dbutton.|........|
|00005170| f2 ff 20 02 01 00 00 00 | ce 01 00 00 ce 01 00 00 |.. .....|........|
|00005180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005190| 00 00 00 00 00 00 54 44 | 01 00 00 00 25 00 00 00 |......TD|....%...|
|000051a0| 58 01 00 00 00 00 00 00 | 85 01 00 00 0f 00 00 00 |X.......|........|
|000051b0| 67 01 00 00 00 00 00 00 | 00 00 00 00 fc 03 00 03 |g.......|........|
|000051c0| 00 55 00 00 e5 00 12 00 | 25 fc 43 f4 00 00 f7 01 |.U......|%.C.....|
|000051d0| 00 a1 fd f9 05 3d 00 fe | 24 00 52 2c ce fc f8 01 |.....=..|$.R,....|
|000051e0| 02 fd fc d9 14 00 4e 6f | 20 63 75 72 73 6f 72 20 |......No| cursor |
|000051f0| 73 70 65 63 69 66 69 65 | 64 2e fd fe 07 00 42 fc |specifie|d.....B.|
|00005200| 2d fd fe 04 00 1e fe 07 | 00 ae f7 02 00 fe 0f 00 |-.......|........|
|00005210| 54 f7 02 00 10 fc 43 2d | 61 ea 93 fd fe 0d 00 99 |T.....C-|a.......|
|00005220| fc 43 f4 00 00 f6 03 00 | fd fe 0f 00 25 fc f5 0d |.C......|....%...|
|00005230| f7 02 00 fd f9 05 92 00 | fe 1f 00 99 fc 43 d9 0f |........|.....C..|
|00005240| 00 55 70 64 61 74 65 20 | 73 75 63 63 65 64 65 64 |.Update |succeded|
|00005250| f4 00 00 f6 04 00 fd fe | 08 00 1b f9 05 d4 00 fe |........|........|
|00005260| 3a 00 99 fc 43 d9 2a 00 | 55 70 64 61 74 65 20 66 |:...C.*.|Update f|
|00005270| 61 69 6c 65 64 2c 20 74 | 68 65 20 70 72 69 6d 61 |ailed, t|he prima|
|00005280| 72 79 20 6b 65 79 20 68 | 61 73 20 63 68 61 6e 67 |ry key h|as chang|
|00005290| 65 64 f4 00 00 f6 04 00 | fd fe 04 00 1e fe 0a 00 |ed......|........|
|000052a0| 99 f4 00 00 f7 05 00 fe | 03 00 55 06 00 08 00 54 |........|..U....T|
|000052b0| 48 49 53 46 4f 52 4d 0b | 00 43 55 52 53 4f 52 41 |HISFORM.|.CURSORA|
|000052c0| 4c 49 41 53 08 00 4c 4c | 55 50 44 41 54 45 0b 00 |LIAS..LL|UPDATE..|
|000052d0| 43 48 45 43 4b 53 4f 55 | 52 43 45 05 00 41 4c 45 |CHECKSOU|RCE..ALE|
|000052e0| 52 54 0c 00 4e 45 58 54 | 43 4f 4e 46 4c 49 43 54 |RT..NEXT|CONFLICT|
|000052f0| 05 00 43 6c 69 63 6b 2c | 00 00 00 00 00 ff ff 31 |..Click,|.......1|
|00005300| 00 21 01 41 02 71 00 41 | 00 72 00 f3 00 d2 00 f3 |.!.A.q.A|.r......|
|00005310| 00 f1 01 81 00 a1 03 41 | 00 a2 00 32 00 00 00 00 |.......A|...2....|
|00005320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00005330| 00 11 00 00 00 a9 01 00 | 00 01 00 00 00 00 29 00 |........|......).|
|00005340| 00 00 ce 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005350| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 5a 54 6f |........|.....ZTo|
|00005360| 70 20 3d 20 31 34 39 0d | 0a 4c 65 66 74 20 3d 20 |p = 149.|.Left = |
|00005370| 31 39 30 0d 0a 48 65 69 | 67 68 74 20 3d 20 32 33 |190..Hei|ght = 23|
|00005380| 0d 0a 57 69 64 74 68 20 | 3d 20 37 32 0d 0a 43 61 |..Width |= 72..Ca|
|00005390| 70 74 69 6f 6e 20 3d 20 | 22 5c 3c 55 70 64 61 74 |ption = |"\<Updat|
|000053a0| 65 22 0d 0a 4e 61 6d 65 | 20 3d 20 22 63 6d 64 55 |e"..Name| = "cmdU|
|000053b0| 70 64 61 74 65 22 0d 0a | 00 00 00 01 00 00 00 0a |pdate"..|........|
|000053c0| 5f 63 6f 6e 66 6c 69 63 | 74 73 00 00 00 01 00 00 |_conflic|ts......|
|000053d0| 00 09 63 6d 64 55 70 64 | 61 74 65 00 00 00 01 00 |..cmdUpd|ate.....|
|000053e0| 00 00 0d 63 6f 6d 6d 61 | 6e 64 62 75 74 74 6f 6e |...comma|ndbutton|
|000053f0| 00 00 00 01 00 00 00 09 | 5f 62 61 73 65 2e 76 63 |........|_base.vc|
|00005400| 78 00 00 00 01 00 00 00 | 0e 5f 63 6f 6d 6d 61 6e |x.......|._comman|
|00005410| 64 62 75 74 74 6f 6e 00 | 00 00 01 00 00 00 0a 5f |dbutton.|......._|
|00005420| 63 6f 6e 66 6c 69 63 74 | 73 00 00 00 01 00 00 00 |conflict|s.......|
|00005430| 0c 67 72 64 43 6f 6e 66 | 6c 69 63 74 73 00 00 00 |.grdConf|licts...|
|00005440| 01 00 00 00 05 5f 67 72 | 69 64 00 00 00 01 00 00 |....._gr|id......|
|00005450| 01 6a 64 69 73 70 6c 61 | 79 5f 63 6f 6c 75 6d 6e |.jdispla|y_column|
|00005460| 20 53 70 65 63 69 66 69 | 65 73 20 74 68 65 20 63 | Specifi|es the c|
|00005470| 6f 6c 75 6d 6e 20 66 72 | 6f 6d 20 6c 6f 6f 6b 75 |olumn fr|om looku|
|00005480| 70 5f 74 61 62 6c 65 20 | 74 6f 20 64 69 73 70 6c |p_table |to displ|
|00005490| 61 79 20 69 6e 20 74 68 | 65 20 64 72 6f 70 20 64 |ay in th|e drop d|
|000054a0| 6f 77 6e 20 6c 69 73 74 | 2e 0d 0a 6c 6f 6f 6b 75 |own list|...looku|
|000054b0| 70 5f 74 61 62 6c 65 20 | 53 70 65 63 69 66 69 65 |p_table |Specifie|
|000054c0| 73 20 74 68 65 20 74 61 | 62 6c 65 20 74 6f 20 6c |s the ta|ble to l|
|000054d0| 6f 6f 6b 75 70 20 74 68 | 65 20 76 61 6c 75 65 73 |ookup th|e values|
|000054e0| 20 74 6f 20 64 69 73 70 | 6c 61 79 20 69 6e 20 74 | to disp|lay in t|
|000054f0| 68 65 20 64 72 6f 70 20 | 64 6f 77 6e 2e 0d 0a 72 |he drop |down...r|
|00005500| 65 74 75 72 6e 5f 63 6f | 6c 75 6d 6e 20 53 70 65 |eturn_co|lumn Spe|
|00005510| 63 69 66 69 65 73 20 74 | 68 65 20 63 6f 6c 75 6d |cifies t|he colum|
|00005520| 6e 20 76 61 6c 75 65 20 | 74 6f 20 72 65 74 75 72 |n value |to retur|
|00005530| 6e 20 74 68 65 20 76 61 | 6c 75 65 20 70 72 6f 70 |n the va|lue prop|
|00005540| 65 72 74 79 20 6f 66 20 | 74 68 65 20 63 6f 6d 62 |erty of |the comb|
|00005550| 6f 20 62 6f 78 2e 0d 0a | 6f 72 64 65 72 5f 63 6f |o box...|order_co|
|00005560| 6c 75 6d 6e 20 53 70 65 | 63 69 66 69 65 73 20 74 |lumn Spe|cifies t|
|00005570| 68 65 20 63 6f 6c 75 6d | 6e 20 74 6f 20 6f 72 64 |he colum|n to ord|
|00005580| 65 72 20 74 68 65 20 72 | 65 63 6f 72 64 73 20 64 |er the r|ecords d|
|00005590| 69 73 70 6c 61 79 65 64 | 20 69 6e 20 74 68 65 20 |isplayed| in the |
|000055a0| 64 72 6f 70 20 64 6f 77 | 6e 20 6c 69 73 74 20 28 |drop dow|n list (|
|000055b0| 6f 70 74 69 6f 6e 61 6c | 29 2e 0d 0a 00 00 00 01 |optional|).......|
|000055c0| 00 00 01 b4 50 52 4f 43 | 45 44 55 52 45 20 43 6c |....PROC|EDURE Cl|
|000055d0| 69 63 6b 0d 0a 49 46 20 | 45 4d 50 54 59 28 54 48 |ick..IF |EMPTY(TH|
|000055e0| 49 53 46 4f 52 4d 2e 43 | 75 72 73 6f 72 41 6c 69 |ISFORM.C|ursorAli|
|000055f0| 61 73 29 0d 0a 09 57 41 | 49 54 20 57 49 4e 44 4f |as)...WA|IT WINDO|
|00005600| 57 20 43 53 5f 4e 4f 41 | 4c 49 41 53 5f 4c 4f 43 |W CS_NOA|LIAS_LOC|
|00005610| 20 54 49 4d 45 4f 55 54 | 20 32 0d 0a 09 52 45 54 | TIMEOUT| 2...RET|
|00005620| 55 52 4e 20 2e 46 2e 0d | 0a 45 4e 44 49 46 0d 0a |URN .F..|.ENDIF..|
|00005630| 0d 0a 4c 4f 43 41 4c 20 | 6c 6c 55 70 64 61 74 65 |..LOCAL |llUpdate|
|00005640| 0d 0a 0d 0a 2a 20 66 6f | 72 63 65 2d 75 70 64 61 |....* fo|rce-upda|
|00005650| 74 65 20 63 75 72 72 65 | 6e 74 20 72 6f 77 0d 0a |te curre|nt row..|
|00005660| 6c 6c 55 70 64 61 74 65 | 20 3d 20 54 41 42 4c 45 |llUpdate| = TABLE|
|00005670| 55 50 44 41 54 45 28 2e | 46 2e 2c 20 2e 54 2e 29 |UPDATE(.|F., .T.)|
|00005680| 0d 0a 0d 0a 54 48 49 53 | 46 4f 52 4d 2e 43 68 65 |....THIS|FORM.Che|
|00005690| 63 6b 53 6f 75 72 63 65 | 28 29 0d 0a 0d 0a 2a 20 |ckSource|()....* |
|000056a0| 44 69 73 70 6c 61 79 20 | 77 68 65 74 68 65 72 20 |Display |whether |
|000056b0| 75 70 64 61 74 65 20 77 | 61 73 20 73 75 63 63 65 |update w|as succe|
|000056c0| 73 73 66 75 6c 20 6f 72 | 20 66 61 69 6c 65 64 20 |ssful or| failed |
|000056d0| 28 65 2e 67 2e 2c 20 70 | 72 69 6d 61 72 79 20 6b |(e.g., p|rimary k|
|000056e0| 65 79 20 63 68 61 6e 67 | 65 64 29 0d 0a 49 46 20 |ey chang|ed)..IF |
|000056f0| 6d 2e 6c 6c 55 70 64 61 | 74 65 0d 0a 09 54 48 49 |m.llUpda|te...THI|
|00005700| 53 46 4f 52 4d 2e 41 6c | 65 72 74 28 57 41 49 54 |SFORM.Al|ert(WAIT|
|00005710| 5f 55 50 44 41 54 45 4f | 4b 5f 4c 4f 43 29 0d 0a |_UPDATEO|K_LOC)..|
|00005720| 45 4c 53 45 0d 0a 09 54 | 48 49 53 46 4f 52 4d 2e |ELSE...T|HISFORM.|
|00005730| 41 6c 65 72 74 28 57 41 | 49 54 5f 55 50 44 41 54 |Alert(WA|IT_UPDAT|
|00005740| 45 46 41 49 4c 31 5f 4c | 4f 43 29 0d 0a 45 4e 44 |EFAIL1_L|OC)..END|
|00005750| 49 46 0d 0a 0d 0a 54 48 | 49 53 46 4f 52 4d 2e 4e |IF....TH|ISFORM.N|
|00005760| 65 78 74 43 6f 6e 66 6c | 69 63 74 0d 0a 0d 0a 45 |extConfl|ict....E|
|00005770| 4e 44 50 52 4f 43 0d 0a | 00 00 00 01 00 00 00 c0 |NDPROC..|........|
|00005780| 43 6f 6c 75 6d 6e 43 6f | 75 6e 74 20 3d 20 2d 31 |ColumnCo|unt = -1|
|00005790| 0d 0a 48 65 69 67 68 74 | 20 3d 20 39 30 0d 0a 48 |..Height| = 90..H|
|000057a0| 69 67 68 6c 69 67 68 74 | 20 3d 20 2e 46 2e 0d 0a |ighlight| = .F...|
|000057b0| 48 69 67 68 6c 69 67 68 | 74 52 6f 77 20 3d 20 2e |Highligh|tRow = .|
|000057c0| 46 2e 0d 0a 4c 65 66 74 | 20 3d 20 31 30 38 0d 0a |F...Left| = 108..|
|000057d0| 52 65 61 64 4f 6e 6c 79 | 20 3d 20 2e 54 2e 0d 0a |ReadOnly| = .T...|
|000057e0| 52 65 63 6f 72 64 53 6f | 75 72 63 65 20 3d 20 22 |RecordSo|urce = "|
|000057f0| 22 0d 0a 53 63 72 6f 6c | 6c 42 61 72 73 20 3d 20 |"..Scrol|lBars = |
|00005800| 31 0d 0a 54 6f 70 20 3d | 20 34 38 0d 0a 56 69 73 |1..Top =| 48..Vis|
|00005810| 69 62 6c 65 20 3d 20 2e | 46 2e 0d 0a 57 69 64 74 |ible = .|F...Widt|
|00005820| 68 20 3d 20 33 37 30 0d | 0a 4e 61 6d 65 20 3d 20 |h = 370.|.Name = |
|00005830| 22 67 72 64 43 6f 6e 66 | 6c 69 63 74 73 22 0d 0a |"grdConf|licts"..|
|00005840| 00 00 00 01 00 00 00 09 | 5f 62 61 73 65 2e 76 63 |........|_base.vc|
|00005850| 78 00 00 00 01 00 00 00 | f4 63 6f 6e 66 6c 69 63 |x.......|.conflic|
|00005860| 74 61 6c 69 61 73 0d 0a | 63 75 72 73 6f 72 61 6c |talias..|cursoral|
|00005870| 69 61 73 20 4e 61 6d 65 | 20 6f 66 20 61 6c 69 61 |ias Name| of alia|
|00005880| 73 20 74 6f 20 63 68 65 | 63 6b 20 66 6f 72 20 63 |s to che|ck for c|
|00005890| 6f 6e 66 6c 69 63 74 73 | 2e 0d 0a 6c 72 6f 77 63 |onflicts|...lrowc|
|000058a0| 6f 6e 66 6c 69 63 74 0d | 0a 6c 61 75 74 6f 63 68 |onflict.|.lautoch|
|000058b0| 65 63 6b 20 41 75 74 6f | 6d 61 74 69 63 61 6c 6c |eck Auto|maticall|
|000058c0| 79 20 63 68 65 63 6b 20 | 6f 6e 20 73 74 61 72 74 |y check |on start|
|000058d0| 75 70 2e 0d 0a 2a 6e 65 | 78 74 63 6f 6e 66 6c 69 |up...*ne|xtconfli|
|000058e0| 63 74 20 0d 0a 5e 61 63 | 6f 6e 66 6c 69 63 74 73 |ct ..^ac|onflicts|
|000058f0| 5b 31 2c 30 5d 20 0d 0a | 2a 63 68 65 63 6b 73 6f |[1,0] ..|*checkso|
|00005900| 75 72 63 65 20 0d 0a 2a | 73 74 61 72 74 63 68 65 |urce ..*|startche|
|00005910| 63 6b 20 43 68 65 63 6b | 73 20 66 6f 72 20 63 6f |ck Check|s for co|
|00005920| 6e 66 6c 69 63 74 73 20 | 69 6e 20 62 75 66 66 65 |nflicts |in buffe|
|00005930| 72 65 64 20 64 61 74 61 | 20 6f 66 20 61 6c 69 61 |red data| of alia|
|00005940| 73 2e 0d 0a 2a 61 6c 65 | 72 74 20 0d 0a 00 00 00 |s...*ale|rt .....|
|00005950| 01 00 00 00 ea 48 65 69 | 67 68 74 20 3d 20 31 38 |.....Hei|ght = 18|
|00005960| 33 0d 0a 57 69 64 74 68 | 20 3d 20 34 39 30 0d 0a |3..Width| = 490..|
|00005970| 44 6f 43 72 65 61 74 65 | 20 3d 20 2e 54 2e 0d 0a |DoCreate| = .T...|
|00005980| 41 75 74 6f 43 65 6e 74 | 65 72 20 3d 20 2e 54 2e |AutoCent|er = .T.|
|00005990| 0d 0a 43 61 70 74 69 6f | 6e 20 3d 20 22 52 65 73 |..Captio|n = "Res|
|000059a0| 6f 6c 76 65 20 43 6f 6e | 66 6c 69 63 74 73 22 0d |olve Con|flicts".|
|000059b0| 0a 4d 61 78 42 75 74 74 | 6f 6e 20 3d 20 2e 46 2e |.MaxButt|on = .F.|
|000059c0| 0d 0a 4d 69 6e 42 75 74 | 74 6f 6e 20 3d 20 2e 46 |..MinBut|ton = .F|
|000059d0| 2e 0d 0a 57 69 6e 64 6f | 77 54 79 70 65 20 3d 20 |...Windo|wType = |
|000059e0| 31 0d 0a 41 6c 77 61 79 | 73 4f 6e 54 6f 70 20 3d |1..Alway|sOnTop =|
|000059f0| 20 2e 54 2e 0d 0a 63 6f | 6e 66 6c 69 63 74 61 6c | .T...co|nflictal|
|00005a00| 69 61 73 20 3d 20 0d 0a | 63 75 72 73 6f 72 61 6c |ias = ..|cursoral|
|00005a10| 69 61 73 20 3d 20 0d 0a | 6c 61 75 74 6f 63 68 65 |ias = ..|lautoche|
|00005a20| 63 6b 20 3d 20 2e 54 2e | 0d 0a 4e 61 6d 65 20 3d |ck = .T.|..Name =|
|00005a30| 20 22 5f 63 6f 6e 66 6c | 69 63 74 73 22 0d 0a 00 | "_confl|icts"...|
|00005a40| 00 00 01 00 00 00 04 66 | 6f 72 6d 00 00 00 01 00 |.......f|orm.....|
|00005a50| 00 00 09 5f 62 61 73 65 | 2e 76 63 78 00 00 00 01 |..._base|.vcx....|
|00005a60| 00 00 02 c6 50 52 4f 43 | 45 44 55 52 45 20 44 65 |....PROC|EDURE De|
|00005a70| 73 74 72 6f 79 0d 0a 4c | 4f 43 41 4c 20 63 43 75 |stroy..L|OCAL cCu|
|00005a80| 72 73 6f 72 0d 0a 0d 0a | 63 43 75 72 73 6f 72 20 |rsor....|cCursor |
|00005a90| 3d 20 22 63 22 20 2b 20 | 54 48 49 53 2e 6e 61 6d |= "c" + |THIS.nam|
|00005aa0| 65 0d 0a 49 46 20 55 53 | 45 44 28 6d 2e 63 43 75 |e..IF US|ED(m.cCu|
|00005ab0| 72 73 6f 72 29 20 54 48 | 45 4e 0d 0a 09 55 53 45 |rsor) TH|EN...USE|
|00005ac0| 20 49 4e 20 26 63 43 75 | 72 73 6f 72 0d 0a 45 4e | IN &cCu|rsor..EN|
|00005ad0| 44 49 46 0d 0a 0d 0a 45 | 4e 44 50 52 4f 43 0d 0a |DIF....E|NDPROC..|
|00005ae0| 50 52 4f 43 45 44 55 52 | 45 20 49 6e 69 74 0d 0a |PROCEDUR|E Init..|
|00005af0| 4c 4f 43 41 4c 20 63 53 | 51 4c 2c 20 63 41 6c 69 |LOCAL cS|QL, cAli|
|00005b00| 61 73 2c 20 63 43 6f 6c | 75 6d 6e 0d 0a 0d 0a 49 |as, cCol|umn....I|
|00005b10| 46 20 21 45 4d 50 54 59 | 28 54 48 49 53 2e 63 6f |F !EMPTY|(THIS.co|
|00005b20| 6e 74 72 6f 6c 53 6f 75 | 72 63 65 29 20 54 48 45 |ntrolSou|rce) THE|
|00005b30| 4e 0d 0a 09 49 46 20 4e | 4f 54 20 22 2e 22 20 24 |N...IF N|OT "." $|
|00005b40| 20 54 48 49 53 2e 63 6f | 6e 74 72 6f 6c 53 6f 75 | THIS.co|ntrolSou|
|00005b50| 72 63 65 20 54 48 45 4e | 0d 0a 09 09 3d 4d 45 53 |rce THEN|....=MES|
|00005b60| 53 41 47 45 42 4f 58 28 | 4e 4f 5f 54 41 42 4c 45 |SAGEBOX(|NO_TABLE|
|00005b70| 5f 4c 4f 43 29 0d 0a 09 | 45 4c 53 45 0d 0a 09 09 |_LOC)...|ELSE....|
|00005b80| 63 41 6c 69 61 73 20 3d | 20 4c 45 46 54 43 28 54 |cAlias =| LEFTC(T|
|00005b90| 48 49 53 2e 63 6f 6e 74 | 72 6f 6c 53 6f 75 72 63 |HIS.cont|rolSourc|
|00005ba0| 65 2c 28 41 54 43 28 22 | 2e 22 2c 54 48 49 53 2e |e,(ATC("|.",THIS.|
|00005bb0| 63 6f 6e 74 72 6f 6c 53 | 6f 75 72 63 65 29 2d 31 |controlS|ource)-1|
|00005bc0| 29 29 0d 0a 09 09 63 43 | 6f 6c 75 6d 6e 20 3d 20 |))....cC|olumn = |
|00005bd0| 52 49 47 48 54 43 28 54 | 48 49 53 2e 63 6f 6e 74 |RIGHTC(T|HIS.cont|
|00005be0| 72 6f 6c 53 6f 75 72 63 | 65 2c 28 4c 45 4e 43 28 |rolSourc|e,(LENC(|
|00005bf0| 54 48 49 53 2e 63 6f 6e | 74 72 6f 6c 53 6f 75 72 |THIS.con|trolSour|
|00005c00| 63 65 29 2d 41 54 43 28 | 22 2e 22 2c 54 48 49 53 |ce)-ATC(|".",THIS|
|00005c10| 2e 63 6f 6e 74 72 6f 6c | 53 6f 75 72 63 65 29 29 |.control|Source))|
|00005c20| 29 0d 0a 09 09 49 46 20 | 49 4e 4c 49 53 54 28 54 |)....IF |INLIST(T|
|00005c30| 59 50 45 28 6d 2e 63 41 | 6c 69 61 73 2b 22 2e 22 |YPE(m.cA|lias+"."|
|00005c40| 2b 6d 2e 63 43 6f 6c 75 | 6d 6e 29 2c 22 44 22 2c |+m.cColu|mn),"D",|
|00005c50| 22 54 22 2c 22 4d 22 2c | 22 47 22 2c 22 4c 22 29 |"T","M",|"G","L")|
|00005c60| 0d 0a 09 09 09 52 45 54 | 55 52 4e 0d 0a 09 09 45 |.....RET|URN....E|
|00005c70| 4e 44 49 46 0d 0a 09 09 | 54 48 49 53 2e 72 6f 77 |NDIF....|THIS.row|
|00005c80| 53 6f 75 72 63 65 54 79 | 70 65 20 3d 20 33 0d 0a |SourceTy|pe = 3..|
|00005c90| 09 09 63 53 51 4c 20 3d | 20 22 53 45 4c 45 43 54 |..cSQL =| "SELECT|
|00005ca0| 20 44 49 53 54 49 4e 43 | 54 20 22 20 2b 20 6d 2e | DISTINC|T " + m.|
|00005cb0| 63 43 6f 6c 75 6d 6e 20 | 2b 20 22 20 46 52 4f 4d |cColumn |+ " FROM|
|00005cc0| 20 22 20 2b 20 6d 2e 63 | 41 6c 69 61 73 20 2b 20 | " + m.c|Alias + |
|00005cd0| 3b 0d 0a 09 09 20 20 22 | 20 49 4e 54 4f 20 43 55 |;.... "| INTO CU|
|00005ce0| 52 53 4f 52 20 63 22 20 | 2b 20 54 48 49 53 2e 6e |RSOR c" |+ THIS.n|
|00005cf0| 61 6d 65 0d 0a 09 09 54 | 48 49 53 2e 72 6f 77 53 |ame....T|HIS.rowS|
|00005d00| 6f 75 72 63 65 20 3d 20 | 6d 2e 63 53 51 4c 0d 0a |ource = |m.cSQL..|
|00005d10| 09 45 4e 44 49 46 0d 0a | 45 4e 44 49 46 0d 0a 0d |.ENDIF..|ENDIF...|
|00005d20| 0a 45 4e 44 50 52 4f 43 | 0d 0a 00 00 00 01 00 00 |.ENDPROC|........|
|00005d30| 03 29 fe f2 ff 20 02 01 | 00 00 00 10 03 00 00 10 |.)... ..|........|
|00005d40| 03 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005d50| 00 00 00 00 00 00 00 00 | 00 f8 87 01 00 00 00 25 |........|.......%|
|00005d60| 00 00 00 77 02 00 00 00 | 00 00 00 c7 02 00 00 1c |...w....|........|
|00005d70| 00 00 00 8f 02 00 00 00 | 00 00 00 00 00 00 00 fc |........|........|
|00005d80| 03 00 03 00 55 00 00 0e | 02 0b 00 af f7 00 00 07 |....U...|........|
|00005d90| f7 01 00 fe 0b 00 ae f7 | 02 00 07 f7 03 00 fe 1e |........|........|
|00005da0| 00 25 fc 43 fb 0a 00 63 | 43 6f 6e 64 69 74 69 6f |.%.C...c|Conditio|
|00005db0| 6e 62 fb 01 00 43 10 fd | f9 05 43 00 fe 0f 00 54 |nb...C..|..C....T|
|00005dc0| f7 00 00 10 fc 43 f7 00 | 00 9b fd fe 04 00 1e fe |.....C..|........|
|00005dd0| 1f 00 54 f7 03 00 10 fc | 43 f7 01 00 43 d9 01 00 |..T.....|C...C...|
|00005de0| 2e f7 01 00 ea b2 f8 01 | 01 06 03 ea b5 fd fe 10 |........|........|
|00005df0| 00 25 fc 43 f7 00 00 a1 | 0a fd f9 05 e9 01 fe 1f |.%.C....|........|
|00005e00| 00 25 fc 43 fb 0a 00 63 | 43 6f 6e 64 69 74 69 6f |.%.C...c|Conditio|
|00005e10| 6e 62 d9 02 00 43 4d 01 | fd f9 05 31 01 fe 87 00 |nb...CM.|...1....|
|00005e20| 25 fc d9 01 00 3c f7 00 | 00 01 f1 0a 00 d9 02 00 |%....<..|........|
|00005e30| 3d 3d f7 00 00 01 0b f1 | 0c 00 d9 04 00 4c 49 4b |==......|.....LIK|
|00005e40| 45 f7 00 00 01 0b f1 0a | 00 d9 02 00 3c 3e f7 00 |E.......|....<>..|
|00005e50| 00 01 0b f1 0a 00 d9 02 | 00 21 3d f7 00 00 01 0b |........|.!=.....|
|00005e60| f1 09 00 d9 01 00 23 f7 | 00 00 01 0b f1 09 00 d9 |......#.|........|
|00005e70| 01 00 3d f7 00 00 01 0b | f1 0a 00 d9 02 00 3e 3d |..=.....|......>=|
|00005e80| f7 00 00 01 0b f1 0a 00 | d9 02 00 3c 3d f7 00 00 |........|...<=...|
|00005e90| 01 0b f1 09 00 d9 01 00 | 3e f7 00 00 01 0b 03 fd |........|>.......|
|00005ea0| f9 05 2d 01 fe 11 00 54 | f7 02 00 10 fc f7 03 00 |..-....T|........|
|00005eb0| f7 00 00 06 fd fe 04 00 | 1e fe 04 00 1e fe 0f 00 |........|........|
|00005ec0| 25 fc 43 f7 02 00 a1 fd | f9 05 e5 01 fe 0d 00 18 |%.C.....|........|
|00005ed0| 48 f9 05 51 01 f9 05 e1 | 01 fe 15 00 0c fc 43 f7 |H..Q....|......C.|
|00005ee0| 01 00 62 d9 02 00 43 4d | 01 fd f9 05 8a 01 fe 24 |..b...CM|.......$|
|00005ef0| 00 54 f7 02 00 10 fc f7 | 03 00 d9 03 00 20 3d 20 |.T......|..... = |
|00005f00| 06 43 f8 02 22 20 06 f7 | 00 00 06 43 f8 02 22 20 |.C.." ..|...C.." |
|00005f10| 06 fd fe 15 00 0c fc 43 | f7 01 00 62 d9 02 00 44 |.......C|...b...D|
|00005f20| 54 01 fd f9 05 bf 01 fe | 20 00 54 f7 02 00 10 fc |T.......| .T.....|
|00005f30| f7 03 00 d9 04 00 20 3d | 20 7b 06 43 f7 00 00 2a |...... =| {.C...*|
|00005f40| 06 d9 01 00 7d 06 fd fe | 08 00 32 f9 05 e1 01 fe |....}...|..2.....|
|00005f50| 1a 00 54 f7 02 00 10 fc | f7 03 00 d9 03 00 20 3d |..T.....|...... =|
|00005f60| 20 06 43 f7 00 00 5a 06 | fd fe 04 00 1c fe 04 00 | .C...Z.|........|
|00005f70| 1e fe 08 00 1b f9 05 fe | 01 fe 0d 00 54 f7 02 00 |........|....T...|
|00005f80| 10 fc d9 00 00 fd fe 04 | 00 1e fe 09 00 42 fc f7 |........|.....B..|
|00005f90| 02 00 fd fe 03 00 55 04 | 00 0a 00 43 43 4f 4e 44 |......U.|...CCOND|
|00005fa0| 49 54 49 4f 4e 0e 00 43 | 43 4f 4e 54 52 4f 4c 53 |ITION..C|CONTROLS|
|00005fb0| 4f 55 52 43 45 0e 00 4c | 43 52 45 54 43 4f 4e 44 |OURCE..L|CRETCOND|
|00005fc0| 49 54 49 4f 4e 0b 00 4c | 43 46 49 45 4c 44 4e 41 |ITION..L|CFIELDNA|
|00005fd0| 4d 45 0e 00 70 61 72 73 | 65 63 6f 6e 64 69 74 69 |ME..pars|econditi|
|00005fe0| 6f 6e 2c 00 00 00 00 00 | ff ff 31 00 b1 00 b1 00 |on,.....|..1.....|
|00005ff0| e1 01 f1 00 41 00 f2 01 | 06 01 f4 01 7a 08 11 01 |....A...|....z...|
|00006000| 41 00 41 00 f3 00 d5 00 | 51 01 41 02 51 01 01 02 |A.A.....|Q.A.Q...|
|00006010| 81 00 a1 01 41 00 41 00 | 81 00 d1 00 41 00 92 00 |....A.A.|....A...|
|00006020| 31 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |1.......|........|
|00006030| 00 00 01 00 00 00 1a 00 | 00 00 04 07 00 00 01 00 |........|........|
|00006040| 00 00 00 29 00 00 00 10 | 03 00 00 00 00 00 00 00 |...)....|........|
|00006050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00006060| 00 00 61 46 6f 6e 74 4e | 61 6d 65 20 3d 20 22 4d |..aFontN|ame = "M|
|00006070| 53 20 53 61 6e 73 20 53 | 65 72 69 66 22 0d 0a 46 |S Sans S|erif"..F|
|00006080| 6f 6e 74 53 69 7a 65 20 | 3d 20 38 0d 0a 48 65 69 |ontSize |= 8..Hei|
|00006090| 67 68 74 20 3d 20 32 33 | 0d 0a 57 69 64 74 68 20 |ght = 23|..Width |
|000060a0| 3d 20 31 37 35 0d 0a 4e | 61 6d 65 20 3d 20 22 5f |= 175..N|ame = "_|
|000060b0| 63 62 6f 64 69 73 74 69 | 6e 63 74 76 61 6c 75 65 |cbodisti|nctvalue|
|000060c0| 73 22 0d 0a 00 00 00 01 | 00 00 07 09 fe f2 ff 20 |s"......|....... |
|000060d0| 02 01 00 00 00 f0 06 00 | 00 f0 06 00 00 00 00 00 |........|........|
|000060e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060f0| 00 00 00 4f 8b 03 00 00 | 00 25 00 00 00 01 06 00 |...O....|.%......|
|00006100| 00 00 00 00 00 87 06 00 | 00 2c 00 00 00 2f 06 00 |........|.,.../..|
|00006110| 00 00 00 00 00 00 00 00 | 00 fc 03 00 03 00 55 00 |........|......U.|
|00006120| 00 41 00 07 00 ae f7 00 | 00 fe 10 00 54 f7 00 00 |.A......|....T...|
|00006130| 10 fc f4 01 00 f7 02 00 | fd fe 11 00 25 fc 43 f5 |........|....%.C.|
|00006140| 0d f7 00 00 aa fd f9 05 | 3a 00 fe 12 00 01 55 53 |........|:.....US|
|00006150| 45 20 49 4e 20 26 63 41 | 6c 69 61 73 0a 04 00 1e |E IN &cA|lias....|
|00006160| fe 03 00 55 03 00 06 00 | 43 41 4c 49 41 53 04 00 |...U....|CALIAS..|
|00006170| 54 48 49 53 04 00 4e 41 | 4d 45 f3 01 0f 00 af f7 |THIS..NA|ME......|
|00006180| 00 00 07 f7 01 00 07 f7 | 02 00 fe 0d 00 18 48 f9 |........|......H.|
|00006190| 05 1c 00 f9 05 ec 01 fe | 12 00 0c fc f7 00 00 f9 |........|........|
|000061a0| 04 0e 07 10 fd f9 05 c9 | 00 fe 9b 00 86 fc 43 d9 |........|......C.|
|000061b0| 7f 00 41 6e 20 69 6e 76 | 61 6c 69 64 20 64 69 73 |..An inv|alid dis|
|000061c0| 70 6c 61 79 20 63 6f 6c | 75 6d 6e 20 6f 72 20 72 |play col|umn or r|
|000061d0| 65 74 75 72 6e 20 63 6f | 6c 75 6d 6e 20 68 61 73 |eturn co|lumn has|
|000061e0| 20 62 65 65 6e 20 73 70 | 65 63 69 66 69 65 64 20 | been sp|ecified |
|000061f0| 69 6e 20 74 68 65 20 27 | 64 69 73 70 6c 61 79 5f |in the '|display_|
|00006200| 63 6f 6c 75 6d 6e 27 20 | 6f 72 20 27 72 65 74 75 |column' |or 'retu|
|00006210| 72 6e 5f 63 6f 6c 75 6d | 6e 27 20 70 72 6f 70 65 |rn_colum|n' prope|
|00006220| 72 74 69 65 73 20 28 63 | 6f 6d 62 6f 20 62 6f 78 |rties (c|ombo box|
|00006230| 20 f4 03 00 f7 04 00 06 | d9 02 00 29 2e 06 f8 02 | .......|...)....|
|00006240| 30 ea 78 fd fe 12 00 0c | fc f7 00 00 f9 04 10 07 |0.x.....|........|
|00006250| 10 fd f9 05 46 01 fe 6b | 00 86 fc 43 d9 4f 00 41 |....F..k|...C.O.A|
|00006260| 6e 20 69 6e 76 61 6c 69 | 64 20 63 6f 6c 75 6d 6e |n invali|d column|
|00006270| 20 68 61 73 20 62 65 65 | 6e 20 73 70 65 63 69 66 | has bee|n specif|
|00006280| 69 65 64 20 69 6e 20 74 | 68 65 20 27 6f 72 64 65 |ied in t|he 'orde|
|00006290| 72 5f 63 6f 6c 75 6d 6e | 27 20 70 72 6f 70 65 72 |r_column|' proper|
|000062a0| 74 79 20 28 63 6f 6d 62 | 6f 20 62 6f 78 20 f4 03 |ty (comb|o box ..|
|000062b0| 00 f7 04 00 06 d9 02 00 | 29 2e 06 f8 02 30 ea 78 |........|)....0.x|
|000062c0| fd fe 12 00 0c fc f7 00 | 00 f9 04 0a 07 10 fd f9 |........|........|
|000062d0| 05 d6 01 fe 7e 00 86 fc | 43 d9 62 00 41 6e 20 69 |....~...|C.b.An i|
|000062e0| 6e 76 61 6c 69 64 20 74 | 61 62 6c 65 20 68 61 73 |nvalid t|able has|
|000062f0| 20 62 65 65 6e 20 73 70 | 65 63 69 66 69 65 64 20 | been sp|ecified |
|00006300| 69 6e 20 74 68 65 20 27 | 64 69 73 70 6c 61 79 5f |in the '|display_|
|00006310| 63 6f 6c 75 6d 6e 27 20 | 6f 72 20 27 6c 6f 6f 6b |column' |or 'look|
|00006320| 75 70 5f 74 61 62 6c 65 | 27 20 70 72 6f 70 65 72 |up_table|' proper|
|00006330| 74 79 20 28 63 6f 6d 62 | 6f 20 62 6f 78 20 f4 03 |ty (comb|o box ..|
|00006340| 00 f7 04 00 06 d9 02 00 | 29 2e 06 f8 02 30 ea 78 |........|)....0.x|
|00006350| fd fe 08 00 32 f9 05 ec | 01 fe 0e 00 86 fc 43 43 |....2...|......CC|
|00006360| 45 f8 02 30 ea 78 fd fe | 04 00 1c fe 03 00 55 05 |E..0.x..|......U.|
|00006370| 00 06 00 4e 45 52 52 4f | 52 07 00 43 4d 45 54 48 |...NERRO|R..CMETH|
|00006380| 4f 44 05 00 4e 4c 49 4e | 45 04 00 54 48 49 53 04 |OD..NLIN|E..THIS.|
|00006390| 00 4e 41 4d 45 db 02 0b | 00 ae f7 00 00 07 f7 01 |.NAME...|........|
|000063a0| 00 fe 0b 00 54 f7 00 00 | 10 fc 61 fd fe 0d 00 18 |....T...|..a.....|
|000063b0| 48 f9 05 23 00 f9 05 b5 | 01 fe 12 00 0c fc 43 f4 |H..#....|......C.|
|000063c0| 02 00 f7 03 00 a1 fd f9 | 05 a7 00 fe 67 00 86 fc |........|....g...|
|000063d0| 43 d9 4b 00 41 20 6c 6f | 6f 6b 75 70 20 74 61 62 |C.K.A lo|okup tab|
|000063e0| 6c 65 20 6d 75 73 74 20 | 62 65 20 73 70 65 63 69 |le must |be speci|
|000063f0| 66 69 65 64 20 69 6e 20 | 74 68 65 20 27 6c 6f 6f |fied in |the 'loo|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
